Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
activecell.specialcells(xlCellTypeVisible) returns column refe
Thanks for that, very much appreciated.
It seems odd behaviour though - any reason for this? "Tom Ogilvy" wrote: A trick I first saw posted by David McRitchie set rangeTwo = Intersect(rangeOne.specialcells(xlCellTypeVisible) ,rangeOne) -- Regards, Tom Ogilvy "Noel" wrote in message ... Hi, can anyone help? I want to identify the visible cells (rangeTwo as range) within a given range (rangeOne as range) ie set rangeTwo = rangeOne.specialcells(xlCellTypeVisible) This code seems to work unless rangeOne is a single cell - then rangeTwo is not contained in rangeOne at all (in fact it returns a reference to all the visible columns on my worksheet)...why?!!!! Thanks again in advance Noel |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
activecell.specialcells(xlCellTypeVisible) returns column refe
it mimics the manual method. (Edit=Goto=Special) If you have one cell
selected, Excel works on the whole sheet. From a manual perspective, it makes a lot of sense. If you are already there, there is no requirement to GoTo and it saves having to select the whole sheet if you want to address the whole sheet. -- Regards, Tom Ogilvy "noel" wrote in message ... Thanks for that, very much appreciated. It seems odd behaviour though - any reason for this? "Tom Ogilvy" wrote: A trick I first saw posted by David McRitchie set rangeTwo = Intersect(rangeOne.specialcells(xlCellTypeVisible) ,rangeOne) -- Regards, Tom Ogilvy "Noel" wrote in message ... Hi, can anyone help? I want to identify the visible cells (rangeTwo as range) within a given range (rangeOne as range) ie set rangeTwo = rangeOne.specialcells(xlCellTypeVisible) This code seems to work unless rangeOne is a single cell - then rangeTwo is not contained in rangeOne at all (in fact it returns a reference to all the visible columns on my worksheet)...why?!!!! Thanks again in advance Noel |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Index with mulitple value returns and muliple column returns | Excel Worksheet Functions | |||
If activecell.column = variable then activecell,offset (0,1) | Excel Discussion (Misc queries) | |||
How do I convert the result of LARGE to the cell (or column) refe. | Excel Worksheet Functions | |||
Worksheet function & SpecialCells(xlCellTypeVisible)? | Excel Programming | |||
XP VBA: Range("A2", ActiveCell.SpecialCells(xlLastCell)).Select | Excel Programming |