Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Using variables in a Range
Im quite new to VB, basically i've seen a range specified like: Range("B4,C4,F4,H4").Select I was just wondering how i could get variables to specify a range of cells. I need the macro to paste data, in columns on the same row, the column will not be changing, but the macro will be...- rybred
- Thread
- Replies: 14
- Forum: VBA Visual Basic for Applications (Microsoft)
