HELP!! I'm a VBA dummy

[timinbristol]

Hi

I'm just starting out in VB so please bear with me. I've heard the best way to learn VB is to record macro's, then edit to your requirements - but how do you edit when you don't know the language!!

For example, I'm trying a vey simple procedure which updates a date range across the top of a page, ie

Jan Feb Mar Apr.....

Now, to do this automatically I need excel to find the last date in the range

HOW DO I DO THAT???

Thanks for reading

Tim

 

[Andrew Poulsom]

This:

With ActiveSheet
   .Cells(1, .Columns.Count).End(xlToLeft).Select
End With

will select the last non empty cell in row 1.