Thread: Strange error??
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bugman[_2_] Bugman[_2_] is offline
external usenet poster
 
Posts: 2
Default 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?