'to retrieve data Worksheets("<sheet name>").Range("<your range>").Value Worksheets("<sheet name>").Cells(<row number>, <column number>).Value 'to set data Worksheets("<sheet name>").Range("<your range>") = <your value/data> Worksheets("<sheet name>").Cells(<row number>, <column number>).Value = <your value/data>
'examples Worksheets("Example").Range("A1:A4") = "hello" Worksheets("Example").Range("D1") = "world" Worksheets("Example").Cells(2, 4).Value = "goodbye"
Advertisements