Posted to microsoft.public.excel.programming
|
|
blank cells
thank you!
-----Original Message-----
If you are happy to have the cell contents as a
regference to the cell
above rather than an absolute value, then try:
Selection.SpecialCells(xlCellTypeBlanks).Select
Selection.FormulaR1C1 = "=R[-1]"
*** Sent via Developersdex http://www.developersdex.com
***
Don't just participate in USENET...get rewarded for it!
.
|