Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a sheet titled 'data' that has source information and row 1 has
columns H to BG with dates. On sheet 'Control' is a cell that has a free format cell for dates to be entered. I have named this cell 'WCDATA' for ease of another piece of code. I am tring to create a macro that will locate the date specified in WCDATA on the data sheet and delete all columns from H until that which matches WCDATA. Fortunately I have been running on a test file and I have tried several options but after considerable hair pulling am seeking assistance as am getting close to deadline now. Any assistance appreciated. R |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
delete columns based on value in one cell | Excel Programming | |||
Delete columns based on cell value | Excel Programming | |||
Delete Row Based On Two Columns | Excel Programming | |||
How can I delete a row based on Columns H and I | Excel Programming | |||
How can I delete a row based on Columns H and I | Excel Programming |