Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting Range
Hello,
I have data in columns A through F and I would like select the last row of data (A:F). I get to the last row by: Selection.End(xlDown).Select How do I then Select colums A:F for that row? Thank you in advance, Dan |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting Range
One way:
Selection.Resize(1, 6).Select or, all in one step: Selection.End(xlDown).Resize(1, 6).Select In article , "Dan" wrote: Hello, I have data in columns A through F and I would like select the last row of data (A:F). I get to the last row by: Selection.End(xlDown).Select How do I then Select colums A:F for that row? Thank you in advance, Dan |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting Range
Hey Dan,
Here is one way selection.end(xldown).columns("A:F").select although selecting is messy -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Dan" wrote in message ... Hello, I have data in columns A through F and I would like select the last row of data (A:F). I get to the last row by: Selection.End(xlDown).Select How do I then Select colums A:F for that row? Thank you in advance, Dan |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting Range
Your solution worked just fine!
Thank you, Dan -----Original Message----- One way: Selection.Resize(1, 6).Select or, all in one step: Selection.End(xlDown).Resize(1, 6).Select In article , "Dan" wrote: Hello, I have data in columns A through F and I would like select the last row of data (A:F). I get to the last row by: Selection.End(xlDown).Select How do I then Select colums A:F for that row? Thank you in advance, Dan . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
selecting a range | Excel Discussion (Misc queries) | |||
Selecting range in list of range names depending on a cell informa | Excel Discussion (Misc queries) | |||
Selecting the end of a range | Excel Programming | |||
Help with selecting a range... | Excel Programming | |||
Help with selecting a range... | Excel Programming |