Guest User

Untitled

a guest
Apr 19th, 2018
76
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.29 KB | None | 0 0
  1. sub writehello()
  2. ' we declare s2 as the sheet we want to work on
  3. dim s2 as worksheet
  4. set s2 = thisworkbook.sheets("sheet2")
  5.  
  6. ' The three examples below will work
  7. s2.cells(3, 2) = "hello" ' cells(row index, col index)
  8. s2.range("B3") = "hello"
  9. s2.[b3] = "hello"
  10. end sub
Add Comment
Please, Sign In to add comment