| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Variable column problem
http://www.box.net/shared/mv0e8fh87p
Hi. I have uploaded a sample data. First sheet is the "Original Data". Second sheet is the formatted sheet where I recorded a macro. 3rd sheet is the code of the macro and 4th sheet is a new sheet which is given to test the macro. Please refer Original sheet. I have a problem with the macro. In the Original sheet, there are variable columns after Col P I have to delete some columns and connect Col R data (the TVR col) to Col I (the duration column) But in some sheets we have 3 TVR col and in some sheet more. Each TVR col has to be connected to Duration. But in case I record a macro, its a problem since it cannot recognize how many variable columns. Need help |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy a range with known start column to variable end column | Excel Programming | |||
| Offset from a variable column to a fixed column | Excel Programming | |||
| Sum cells based on a row variable and seperate column variable | Excel Worksheet Functions | |||
| Having a problem using a variable to add a 'name' | Excel Programming | |||
| Problem trying to us a range variable as an array variable | Excel Programming | |||
Threaded Mode
