Use row and column index to reference cell : Cells « Excel « VBA / Excel / Access / Word






  1. VBA / Excel / Access / Word
  2. Excel
  3. Cells

Use row and column index to reference cell

 
Sub ReferAcrossWorksheets3()
  Range(Sheets("Sheet1").Cells(1, 1), Sheets("Sheet1").Cells(10, 5)).Font.Bold = True
End Sub








Related examples in the same category

1.Select entire sheet
2.Set cell value with For Loop
3.Cells(Rows.Count, "A").End(xlUp).Select
4.looping through a worksheet range using a For/Next loop.
5.Cells.Find: Get Real Last Cell
6.Get cell value
7.Sum Cells Based on the Interior Color
8.Entering a value in the next empty cell
9.Use the AutoFill function by specifying the destination range
10.Using Replace Programmatically to Set the Correct Range
11.Calling CurrentRegion to Inspect a List's Useful Characteristics