| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change Reference to Columns in a Macro
hi, is there a way to modify the reference to columns,
to be from a different single cell, such as INDIRECT.. within a macro / script? Thanks the type of lines I want to reference a Range("A1").Value Columns("B:C").Select Range("D:E").Select Intersect(Me.Range("F:G"), With Me.Cells(.Row, "H") |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Shortcut to change change cell reference to Absolute reference? | Excel Worksheet Functions | |||
| change change cell reference to Absolute reference | Excel Discussion (Misc queries) | |||
| how do I change macro relative reference? no stop recording tool | Excel Discussion (Misc queries) | |||
| How do I change my cell reference columns from number to alphabet? | Excel Worksheet Functions | |||
| Change workbook sheet reference using cell A1 to change a vairable | Excel Worksheet Functions | |||
Threaded Mode
