| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select a range of columns based on active cell
Cells(ActiveCell.Row,"H").Resize(1,20).Select
or ActiveCell.Offset(0, 7).Resize(1,20).Select -- Regards, Tom Ogilvy "Steve" wrote in message news:3fafc07f$0$22368$afc38c87@... Hello everyone. I am trying to select columns H:AA of the row that the active cell is on. I can select column H with the code snippet below, but I don't know how to select a range: ActiveCell.Offset(0, 7).Activate Thank you in advance!! -Steve |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Row select mode to highlight active row of active cell | Excel Discussion (Misc queries) | |||
| How select active rows from A to D columns? | Excel Discussion (Misc queries) | |||
| How can change range to select active rows instead of :=Range("S10 | Excel Discussion (Misc queries) | |||
| how can I select a range of cells based on a value of a cell? | Excel Discussion (Misc queries) | |||
| Select cell from range based on input in excel xp | Excel Discussion (Misc queries) | |||
Linear Mode
