Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how can i know the hidden by programming
set rng = columns(1).SpecialCells(xlvisible)
rng will hold a reference to the cells in column 1 for the rows that are visible. You can then do for each cell in rng cell.offset(0,20).Value = rnd() Next as an example. -- Regards, Tom Ogilvy <i wrote in message ... how can i use the Excel.worksheet object to deterimine which row(column) is hidden,so my program can process the data that is not hidden |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2007 Worksheet, Hidden Columns, .CSV Format Saves Hidden Column Da | Excel Discussion (Misc queries) | |||
Hidden Columns No Longer Hidden after Copying Worksheet? | Excel Discussion (Misc queries) | |||
How do I detect hidden worksheets or hidden data on a worksheet? | Excel Discussion (Misc queries) | |||
I need my Hidden Rows to stay hidden when I print the sheet. | Excel Discussion (Misc queries) | |||
Saving hidden data with a worksheet (preferably without using a hidden sheet) | Excel Programming |