Range in Macro error

R

rick_mc

I have a declared RANGE object. I checked the contents of rng.Row and it is
correct, but I can't seem to use it in the following code. I have this error:
Runtime Error - 1004
Method 'Range' of object '_global" failed

Dim rng As Range
Set rng = Cells(Rows.Count, 1).End(xlUp).Offset(1, 0)
Sheets("RAWDATA").Visible = True
Sheets("RAWDATA").Select
Range("A2").Select
Selection.QueryTable.Refresh BackgroundQuery:=False
Selection.Copy
Sheets("Data").Select
Range(rng.Row, 1).Select
 

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

Code execution is correct but generates Error :The file you aretrying to open is in a different form 3
Code does not error but no copy either 4
Dynamic Autofill Error 1
Convert list to UPPER, lower & Proper cases. 21
Object variable or with Block variable not set 9
Help merging two VBA codes 2
Eliminate blanks while copy row and transpose 11
Clean this select case code up a bit. 2

Top