Hello. Why is this range code not working?
Please Login or Register to view this content.
Hello. Why is this range code not working?
Please Login or Register to view this content.
Cells(3, Column) should not be inside the quotes.
It should look something like this.
Note I've added Copy because you can't just have Range on it's own, you need to do something with it.Please Login or Register to view this content.
If posting code please use code tags, see here.
Please Login or Register to view this content.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Thanks. Why do you put a comma and not a ":"?
You use : in a range address, you aren't using an address here.
If you wanted to you could do it like this.
In that code "B3:" & Cells(3,Column).Address will make up the range address.Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks