Thread: [Solved] macro, data import from the ONLY text file in current folder
View Single Post
 
Old 06-16-2012, 02:44 PM
ue418 ue418 is offline Windows 7 32bit Office 2000
Novice
  
Join Date: May 2012
Posts: 17
ue418 is on a distinguished road
Default Okay, I got it...
I had to change the "Range" part of the command from =Range("A3") to =Range("Sheet1!A3"). Now it works fine, even when I click the macro on Sheet2! Thanks for reading.

Rick
Reply With Quote