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
 

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.

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.
 

Forum statistics

Threads
1,141,667
Messages
5,707,723
Members
421,525
Latest member
carian1980

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top