Posted to microsoft.public.excel.programming

BEEJAY

external usenet poster

Posts: 247

Borders on Fixed # of columns, Variable # of Rows

' Select range to put borders on
' B3 thru F3 and down to last row

LastRow = Worksheets(1).Cells(Rows.Count, "E").End(xlUp).Row
Range ("B3:G" & LastRow)

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

With Selection.Borders(xlEdgeLeft)

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Rows & Columns Fixed Width / Height	Elgee	Excel Discussion (Misc queries)	2	August 22nd 08 10:19 PM
Fixed 26 million rows, now 16,000 columns- help help!	The BusyHighLighter[_2_]	Excel Discussion (Misc queries)	2	August 1st 07 04:14 AM
Fixed column, variable rows	Vasilis Tergen	Excel Programming	5	December 3rd 06 02:14 AM
Setting borders for two rows and all columns on spread sheet	R OLEJAR	Excel Worksheet Functions	0	February 1st 06 04:19 PM
Printing fixed columns and rows	rcorona106	Excel Programming	4	December 19th 03 12:03 AM

All times are GMT +1. The time now is 02:08 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us