Borders on Fixed # of Columns, Variable # of Rows

B

BEEJAY

Looking to put "std" width borders on all but outside edges of range
which should be "heavy"
Getting stuck identifying the "variable" range.

Fixed Columns: B3 thru F3
Variable Rows: Any possible number

I got:

LastRow = Worksheets(1).Cells(Rows.Count, "E").End(xlUp).Row
Range ("B3:G" & LastRow) <<<<<<< Comes up as "COMPILE ERROR"



Selection.Borders(xlDiagonalDown).LineStyle = xlNone
Selection.Borders(xlDiagonalUp).LineStyle = xlNone

With Selection.Borders(xlEdgeLeft)
 
J

Jim Thomlinson

Based on the rest of your code you probably want to select that range. So
just add the .select at the end something like this...

Range("B3:G" & LastRow).select
 
B

BEEJAY

Gentlemen:
Thanks for the prompt response.
I'll just go and wipe the egg off my face now!!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top