Using Range Name in Range.Select

U

UncleJohnX

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
capturing current range of cells 2
Macro to use information in a cell to locate and send files using outlook 0
Create Sheets from a Range and Copy Data on copy Data on newlycreated Sheets with the Sheet Names 2
VBA Worksheet_Change not working on new sheets. 2
Dynamic Offset from an Application.Goto cell = Date or Time 10
Insert image into cell using C# and Excel interop?? 0
Macro to copy value in field and insert it into filter 2

Top