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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Please help me get around this:
don't know if this is the best way, but it works for me (replace your first line with this): - '=== Range("A65536").End(xlUp).Select If ActiveCell.Value "" Then ActiveCell.Offset(1, 0).Select End If '=== hth, tim "CarolineHedges" <CarolineHedges.2ca3n5_1155136891.8779@excelforu m-nospam.com wrote in message news:CarolineHedges.2ca3n5_1155136891.8779@excelfo rum-nospam.com... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Please help me get around this:
Thank you What does this line mean? If ActiveCell.Value "" Then -- CarolineHedges ------------------------------------------------------------------------ CarolineHedges's Profile: http://www.excelforum.com/member.php...o&userid=35705 View this thread: http://www.excelforum.com/showthread...hreadid=569941 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Please help me get around this:
it just means if the active cell has an entry, then move to the next row
(i'm guessing this would normally be the case). if the cell is empty, it stays in that cell (this would only apply where there is nothing in there are no entries in the column) hth, tim "CarolineHedges" <CarolineHedges.2ca514_1155138598.4934@excelforu m-nospam.com wrote in message news:CarolineHedges.2ca514_1155138598.4934@excelfo rum-nospam.com... Thank you What does this line mean? If ActiveCell.Value "" Then -- CarolineHedges ------------------------------------------------------------------------ CarolineHedges's Profile: http://www.excelforum.com/member.php...o&userid=35705 View this thread: http://www.excelforum.com/showthread...hreadid=569941 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|