while running the macro, how do you populated cell A1 of a different sheet without first seleting sheet the desired sheet. Example im on sheet 1 and iwant to move a value "TEST" to cell A1 of sheet3?
while running the macro, how do you populated cell A1 of a different sheet without first seleting sheet the desired sheet. Example im on sheet 1 and iwant to move a value "TEST" to cell A1 of sheet3?
Last edited by teachMeExcel; 08-27-2009 at 01:08 AM.
try
you can change pritty much everythink without selecting the sheet just need to tell that line to use sheet1.Please Login or Register to view this content.
Thanks Rennie. It works
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks