Code: Select all
ActiveSheet.Range("A2:A" & LastRow) = "TEXTVALUE"
Want to put something into A2:Axxx?
Jump to A1: Ctrl+Home
One down: down arrow
Expand from A2 to last used cell: Ctrl+Shift+End
Keep range selection and goto first column: Shift+Home
Now A2:Axxx is selected, type the value and hit Alt+Enter
Code: Select all
ActiveSheet.Range("AB2:AB" & LastRow) = "ANYNUMBER"
Want to put something into AB2:ABxxx?
Jump to last used cell: Ctrl+End
Let's say we are in BVxxx, which is shown in the name box (left of the formula bar.
Change "BVxxx" to "AB2:ABxxx" [Enter]
Now AB2:ABxxx is selected, type the value and hit Alt+Enter