Strange error??
I found a better solution:
With Worksheets(V_Range.Worksheet.Name)
This one works perfectly great...
This problem sounds like an Excel bug, don't you think?
I thought that perhaps my ranges were erroneous, but doing
V_Range.Rows(2).Activate
or
(.Range(.Cells(3, V_Range.Column), .Cells(GV_NumProjects
+ 1, V_Range.Column + V_Range.Columns.Count - 1)).Activate
works perfectly... Only he copy function doesn't work...
Strange, isn't it?
|