Hello. Why is this range code not working?
Range ("B3:(Cells(3,Column)")
Hello. Why is this range code not working?
Range ("B3:(Cells(3,Column)")
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.Range ("B3", Cells(3,Column)).Copy
If posting code please use code tags, see here.
MyData = Range("B3", cells(3,4)).value
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.Range ("B3:" & Cells(3,Column).Address).Copy
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks