| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sorry... no Google results!
Hi all...
I've Googled this to death... and found no prior answers to this one... for multiple selected cells (a selection)... and I want to only delete the visible cells in that selection... how? Thx, SMS |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Sorry... no Google results!
Hi rci
do you mean "delete" or "clear contents" ... for clear contents the code would be ---- Selection.SpecialCells(xlCellTypeVisible).ClearCon tents ----- -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "rci" wrote in message ... Hi all... I've Googled this to death... and found no prior answers to this one... for multiple selected cells (a selection)... and I want to only delete the visible cells in that selection... how? Thx, SMS |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Sorry... no Google results!
SMS,
If by "delete" you mean clear then something like this: Selection.SpecialCells(xlCellTypeVisible).ClearCon tents If you want to delete the entire row that contains the visible cell then something like this: Selection.SpecialCells(xlCellTypeVisible).EntireRo w.Delete hth, Doug "rci" wrote in message ... Hi all... I've Googled this to death... and found no prior answers to this one... for multiple selected cells (a selection)... and I want to only delete the visible cells in that selection... how? Thx, SMS |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Sorry... no Google results!
Wow... you guys are awesome... Julie, you anticipated that I really meant clear contents... this works perfect! Are you married? :-) JulieD wrote: : Hi rci : do you mean "delete" or "clear contents" ... for clear contents the code : would be : ---- : Selection.SpecialCells(xlCellTypeVisible).ClearCon tents : ----- : -- : Cheers : JulieD : check out www.hcts.net.au/tipsandtricks.htm : ...well i'm working on it anyway : "rci" wrote in message : ... : Hi all... : I've Googled this to death... and found no prior answers to this one... : : for multiple selected cells (a selection)... and I want to only delete : the : visible cells in that selection... how? : : Thx, : : SMS |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Sorry... no Google results!
http://groups.google.co.uk/groups?q=...tart=10& sa=N
All one line -- Regards, Tom Ogilvy "rci" wrote in message ... Hi all... I've Googled this to death... and found no prior answers to this one... for multiple selected cells (a selection)... and I want to only delete the visible cells in that selection... how? Thx, SMS |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Sorry... no Google results!
yep, but might be open to offers :) ... glad to assist
-- Cheers JulieD "rci" wrote in message ... Wow... you guys are awesome... Julie, you anticipated that I really meant clear contents... this works perfect! Are you married? :-) JulieD wrote: : Hi rci : do you mean "delete" or "clear contents" ... for clear contents the code : would be : ---- : Selection.SpecialCells(xlCellTypeVisible).ClearCon tents : ----- : -- : Cheers : JulieD : check out www.hcts.net.au/tipsandtricks.htm : ...well i'm working on it anyway : "rci" wrote in message : ... : Hi all... : I've Googled this to death... and found no prior answers to this one... : : for multiple selected cells (a selection)... and I want to only delete : the : visible cells in that selection... how? : : Thx, : : SMS |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert Google Business Search Results to Excel? | Excel Discussion (Misc queries) | |||
| Problems with Google | Excel Worksheet Functions | |||
| Excel Discussion (Misc queries) | ||||
| Google archives | Excel Programming | |||
| A pun on Google | Excel Programming | |||
Linear Mode
