code_junkie

How can I write an Excel macro to select a group of cells?

Nov 12th, 2011
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.15 KB | None | 0 0
  1. Public Sub selectCells()
  2. Range("F3:BJ3").Select
  3. End Sub
  4.  
  5. Public Sub selectCellsAndCopy()
  6. Range("F3:BJ3").Select
  7. Selection.Copy
  8. End Sub
Add Comment
Please, Sign In to add comment