HELP!! I'm a VBA dummy

timinbristol

New Member
Joined
Oct 6, 2006
Messages
1
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
 

Some videos you may like

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
This:

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

will select the last non empty cell in row 1.
 

Watch MrExcel Video

Forum statistics

Threads
1,114,041
Messages
5,545,685
Members
410,697
Latest member
srishtijain0708
Top