Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
error using a reference in a range
Hi, I have the following code: Code ------------------- iLastRow3 = Cells(Rows.Count, "B").End(xlUp).Row iLastColumn3 = Cells(iLastRow2, Columns.Count).End(xlToLeft).Column iLastCell = Cells(iLastRow3, iLastColumn3).Address Range("B7:iLastCell").Select With Selection.Borders(xlEdgeLeft) .LineStyle = xlContinuous .Weight = xlMedium .ColorIndex = xlAutomatic End With With Selection.Borders(xlEdgeTop) .LineStyle = xlContinuous .Weight = xlMedium .ColorIndex = xlAutomatic End With With Selection.Borders(xlEdgeBottom) .LineStyle = xlContinuous .Weight = xlMedium .ColorIndex = xlAutomatic End With With Selection.Borders(xlEdgeRight) .LineStyle = xlContinuous .Weight = xlMedium .ColorIndex = xlAutomatic End With With Selection.Borders(xlInsideVertical) .LineStyle = xlContinuous .Weight = xlHairline .ColorIndex = xlAutomatic End With With Selection.Borders(xlInsideHorizontal) .LineStyle = xlContinuous .Weight = xlHairline .ColorIndex = xlAutomatic End Wit ------------------- Problem is I get an error for the line "range("B7:iLastCell").select". What should I change in the code to fix this problem? Thanks i advance -- leonida ----------------------------------------------------------------------- leonidas's Profile: http://www.excelforum.com/member.php...fo&userid=3537 View this thread: http://www.excelforum.com/showthread.php?threadid=56654 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
error using a reference in a range
Hi Leonidas,
Problem is I get an error for the line "range("B7:iLastCell").select". Try: Range("B7", iLastCell).Select --- Regards, Norman "leonidas" wrote in message ... Hi, I have the following code: Code: -------------------- iLastRow3 = Cells(Rows.Count, "B").End(xlUp).Row iLastColumn3 = Cells(iLastRow2, Columns.Count).End(xlToLeft).Column iLastCell = Cells(iLastRow3, iLastColumn3).Address Range("B7:iLastCell").Select With Selection.Borders(xlEdgeLeft) .LineStyle = xlContinuous .Weight = xlMedium .ColorIndex = xlAutomatic End With With Selection.Borders(xlEdgeTop) .LineStyle = xlContinuous .Weight = xlMedium .ColorIndex = xlAutomatic End With With Selection.Borders(xlEdgeBottom) .LineStyle = xlContinuous .Weight = xlMedium .ColorIndex = xlAutomatic End With With Selection.Borders(xlEdgeRight) .LineStyle = xlContinuous .Weight = xlMedium .ColorIndex = xlAutomatic End With With Selection.Borders(xlInsideVertical) .LineStyle = xlContinuous .Weight = xlHairline .ColorIndex = xlAutomatic End With With Selection.Borders(xlInsideHorizontal) .LineStyle = xlContinuous .Weight = xlHairline .ColorIndex = xlAutomatic End With -------------------- Problem is I get an error for the line "range("B7:iLastCell").select". What should I change in the code to fix this problem? Thanks in advance! -- leonidas ------------------------------------------------------------------------ leonidas's Profile: http://www.excelforum.com/member.php...o&userid=35375 View this thread: http://www.excelforum.com/showthread...hreadid=566548 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error Message - Input Range must be a contiguous Reference Help!!! | Excel Discussion (Misc queries) | |||
Named range as chart data reference (error) | Charts and Charting in Excel | |||
Conflict with valid range reference error | Excel Discussion (Misc queries) | |||
automatic range - named range give me circular reference... | Excel Discussion (Misc queries) | |||
Can you get the range reference for each page in a worksheet print range? | Excel Programming |