Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Please help me get around this:
Selection.End(xlDown).Select Selection.Offset(2, 0).Select ActiveCell.FormulaR1C1 = "Total Sales" Is there a different formula I can use for the 1st line of the above, to get around the problem it creates when there is only one row of data in the block? Thanks Caroline -- CarolineHedges ------------------------------------------------------------------------ CarolineHedges's Profile: http://www.excelforum.com/member.php...o&userid=35705 View this thread: http://www.excelforum.com/showthread...hreadid=569941 |