excel VBA Range for columns using count

Question

In my code I have the following statement that works just the way I want it. The question is how would I rewrite this to work for columns?

lastRow = Sheets(sName).Range("C" & Rows.count).End(xlUp).row

so far I have...

partNumber = Sheets("RM_RESULTS").Range(Columns.count & 1).End(xlLeft).Column

It's obviously something so simple but everything I try...no luck.

Kᴀτᴢ · Accepted Answer · 2015-01-20 11:00:26Z

1

partnumber = Cells(1, Columns.Count).End(xlToLeft).Column

Set Cells(1 as needed with your cellnumber

answered Jan 20, 2015 at 11:00

Kᴀτᴢ

2,1966 gold badges33 silver badges60 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1