| Home |
| Search |
| Today's Posts |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
hide columns from find
Apparently yours posted while I was working on my response to Steve.
Tom Ogilvy wrote: Guess you need to read everybody's response. -- Regards, Tom Ogilvy "davegb" wrote in message ups.com... I did some more testing. When I run the macro on other sheets in the workbook (the ones the macro can't find when run from the first sheet), I get "Range method of object failed" on WkSht.Range(Columns(lColTop), Columns("AC")).Hidden = True I watched the values for both lColTop and the found cell and both are correct. Any ideas? Thanks for the help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Want to Hide columns in spreadsheet but NOT hide data in chart. | Charts and Charting in Excel | |||
| Hide/Unhide columns using button on top over relevant columns | Excel Discussion (Misc queries) | |||
| hide a worksheet so that a macro can still find it | Excel Worksheet Functions | |||
| Excel button :: Filter columns by value - possible? Additionally, hide certain columns | Excel Programming | |||
| find and delete duplicate entries in two columns or find and prin. | Excel Programming | |||
Threaded Mode
