Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- sub writehello()
- ' we declare s2 as the sheet we want to work on
- dim s2 as worksheet
- set s2 = thisworkbook.sheets("sheet2")
- ' The three examples below will work
- s2.cells(3, 2) = "hello" ' cells(row index, col index)
- s2.range("B3") = "hello"
- s2.[b3] = "hello"
- end sub
Add Comment
Please, Sign In to add comment