I have had a lot of issues with the 'Select method of Range class failed', which is the 1004 error. I have seen several responses to this error from various sources. The main reason I get this, is due to the fact that I record a lot of my macros, which include shifting from sheet to sheet, cutting and copying, etc............
Rather than recording the macro, how would a programmer enter these functions into VBA properly. I have been told not to use the Select or Activate in code, but I am not sure how to get around this. If I need to copy and range from one sheet to another, what is the proper way to do this in code?
S/T
Bookmarks