I have 6 static tabs and an additional one Result.
In the Result Sheet i need to copy the same range from all 6 sheets e.x Range("D14:I14")
WHat i did until now, is not ok as i have something like this from my macro:
JOhn D D Johnny L Coker A House P Joe DMan
#REF! #REF! #REF! #REF! #REF! #REF! #REF!
#REF! #REF! #REF! #REF! #REF! #REF! #REF!
#REF! #REF! #REF! #REF! #REF! #REF! #REF!
#REF! #REF! #REF! #REF! #REF! #REF! #REF!
#REF! #REF! #REF! #REF! #REF! #REF! #REF!
#REF! #REF! #REF! #REF! #REF! #REF! #REF!
#REF! #REF! #REF! #REF! #REF! #REF! #REF!
#REF! #REF! #REF! #REF! #REF! #REF! #REF!
If someone could help me, i would owe you a lot!
I should have only 6 lines, but i got 8 :D and one extra column![]()
Please Login or Register to view this content.
Bookmarks