Last Filled Column
 

What is the syntax for this expected result? For example replace "Last
filled column"

Columns("A:Last filled Column").autofit

TIA

Greg

Last Filled Column
 

Range("A1").resize(,cells(1,columns.Count).end(xlt oleft).column).entirecolum
n.Select


--

HTH

RP
(remove nothere from the email address if mailing direct)


"GregR" wrote in message
ps.com...
What is the syntax for this expected result? For example replace "Last
filled column"

Columns("A:Last filled Column").autofit

TIA

Greg

Last Filled Column
 

Bob, thank you