ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   running the same record macro on different spreadsheets (https://www.excelbanter.com/new-users-excel/166505-running-same-record-macro-different-spreadsheets.html)

gwtechie72

running the same record macro on different spreadsheets
 
I got have my recorded macro setup the way I want, however when I want to run
it on a new update spreadsheet I cant. Is there a way to run this recorded
macro, without having to re-create it all over again?

Barb Reinhardt

running the same record macro on different spreadsheets
 
I'm guessing that you've hardcoded a worksheet reference of some sort.
Could you post your macro and someone can assist with modifying it?
--
HTH,
Barb Reinhardt



"gwtechie72" wrote:

I got have my recorded macro setup the way I want, however when I want to run
it on a new update spreadsheet I cant. Is there a way to run this recorded
macro, without having to re-create it all over again?


Max

running the same record macro on different spreadsheets
 
I wonder why the simple index/match didn't cut it for you.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---




All times are GMT +1. The time now is 05:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com