By using listi.net you agree to our cookie policy, We and our partners operate globally and use cookies, for multiple purposes

listi.net

Cells

Cells is the VBA Collection of all the cells on a spreadsheet

Go to the Immediate Window and enter the following

Immediate Window

? Cells.count

Cells(4,2).select

Cells(3,1) = "abcd"

Cells.count uses the count property to show you the number of cells in the spreadsheet

Cells(4,2).Select

Cells(3,1) = "abcd" puts the string "abcd" into row 4 column 2 or B4