| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VBA: Column Select then Data Select then return to cell A1
How do you write in VBA:-
to select a column then select the range of data held in the column (say B1) then return to Cell a1. The data in the column can change in the workbook as it is updated regulary, so the range of data in the column varies constantly. There are column headings so the range in column B1 must start at B2. Many thanks -- James |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| select max value from row of data and column containing max value | Excel Worksheet Functions | |||
| Formula to select every third cell in a very long column of data? | Excel Discussion (Misc queries) | |||
| Using formulas to select cells (Ex: Select every nth cell in a col | Excel Discussion (Misc queries) | |||
| Select cell, Copy it, Paste it, Return to Previous cell | Excel Discussion (Misc queries) | |||
| Select cell containing specific text &return value from another ce | Excel Worksheet Functions | |||
![James C[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
