londresw
09-15-2008, 12:04 PM
Problem 1
If I have a block of data with variable height and width, how can I have VBA work out how wide that block is, for selection purposes?
i.e.
It's relatively easy to select a row which is 5 wide, because I know that I just have to do a range from say A1:E1 but if I don't know in advance how wide the block is going to be, but will always need entire width of the data... how can I work this out?
Problem 2
I need to know how to change the names of sheets?
e.g. change "sheet2" to "International"
and also, how to create new sheets?
Problem 3
If I have a body of data that I've pasted into say 'sheet2', how do I go to the row 1 beneath the bottom left of that body, so as to paste more, potentially, later?
I'm sorry to be a pain, I know these things will be easy to someone but I'm struggling as I'm new. I'm enjoying learning though and want to succeed in my brief so all help greatly appreciated.
Cheers all.
If I have a block of data with variable height and width, how can I have VBA work out how wide that block is, for selection purposes?
i.e.
It's relatively easy to select a row which is 5 wide, because I know that I just have to do a range from say A1:E1 but if I don't know in advance how wide the block is going to be, but will always need entire width of the data... how can I work this out?
Problem 2
I need to know how to change the names of sheets?
e.g. change "sheet2" to "International"
and also, how to create new sheets?
Problem 3
If I have a body of data that I've pasted into say 'sheet2', how do I go to the row 1 beneath the bottom left of that body, so as to paste more, potentially, later?
I'm sorry to be a pain, I know these things will be easy to someone but I'm struggling as I'm new. I'm enjoying learning though and want to succeed in my brief so all help greatly appreciated.
Cheers all.