| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Extending Selection of Column to the next Column to the Right
I am utilizing a find scenario where I locate data in a cell and then select
the column Selection.EntireColumn.Select From here I need to extend my selection to include the column to the right. Can someone assist with this code? Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Extending Selection of Column to the next Column to the Right
Sub foo()
Range(Selection, Selection.Offset(0, 1)).EntireColumn.Select End Sub SkyEyes wrote: I am utilizing a find scenario where I locate data in a cell and then select the column Selection.EntireColumn.Select From here I need to extend my selection to include the column to the right. Can someone assist with this code? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Word Wrap and extending cell/row/column size | Excel Discussion (Misc queries) | |||
| How to delete a section of column extending to 2nd page in Excel? | Excel Discussion (Misc queries) | |||
| Need help hiding/unhiding column based on autofilter selection in a different column | Excel Programming | |||
| extending selection | Excel Discussion (Misc queries) | |||
| Extending Selection | Excel Programming | |||
Linear Mode
