Using Range Name in Range.Select

Joined
Dec 13, 2009
Messages
1
Reaction score
0
I’m still new to Excel programming and I need some help with using a range name in a Range.Select Macro.

This macro will increment a cell location on one worksheet (CountNum) which will in turn spit out a cell location to goto (Dbase_Loc).

Public Sub Cust_Dbase2()

Sheets("Accounts").Range("CountNum").Value = Sheets("Accounts").Range("CountNum") + 1

Sheets("Cust_Accts").Select

Here is where I will use the new found cell location (Dbase_Loc) in a Range.Select statement to goto the cell location on the Cust_Acct worksheet.

All help will be appreciated
 
Back
Top