I am receiving an error with the DeBugger highlighting the last line of code below.
I attempted Sheets("APR_ALL_STATES").Range("aprAllStatesA") &
Worksheets("APR_ALL_STATES").Range("aprAllStatesA").Select to no avail.
Thanks in advance.
Dim bHold, fHold, yHold, zHold, aprAllStatesA, aprAllStatesT As Range
Dim oBook As Workbook
'''''GEOLOC
Set aprAllStatesA = Range("A3")
Set aprAllStatesT = Range("T3")
For i = 1 To 5000
''''''''B-F
Sheets("APR_ALL_STATES").Select
Range("aprAllStatesA").Select
Welcome to the forum, scm.
Please take a few minutes to read the forum rules, and then edit your post to add code tags.
In your first declaration, everything except aprAllStatesT is declared as a Variant, since the data type is not specified.
One possible form for the last line isaprAllStatesT.Select
Last edited by shg; 06-03-2009 at 05:19 PM.
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks