on the code below, I'm having trouble setting up the range.
B1 will be a variable later, but I'm getting error where it says ":"
What is the proper way of writing this?
Worksheets("Sheet2").Range(Range("B1").Offset(0,4):Range("B1").Offset(0,16)).Select
Thank you
There are several ways it could be done. Here are two.
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Hi, gameybeets,
Ciao,Please Login or Register to view this content.
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Thank you!!!
Works good
Last edited by gameybeets; 05-23-2014 at 12:34 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks