| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
select a range in a column
I have two columns in a sheet say column A and B. In Column A I have invoice
numbers and in column B a formula which identifes duplicate invoice numbers. As the data varies in length in column A when opening the sheet I want to ensure that a formula in column B returns a value for all the entries in Column A. As part of a macro instruction how can I write in VBA a sequence which will cover all the entires in Column A, which will then allow me to copy the formula in Column B thus ensuring the variable number number of entires in Column A are covered. -- hopalong |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Select range using row and column number addresses | Excel Discussion (Misc queries) | |||
| Select Range based on column name and not A1 notations | Excel Discussion (Misc queries) | |||
| Select a Range of column depending on the date | Excel Worksheet Functions | |||
| select date range in column | Excel Worksheet Functions | |||
| hOW DO i CHANGE COLUMN WIDTH FOR ONLY A SELECT RANGE OF CELLS? | Excel Discussion (Misc queries) | |||
Threaded Mode
