Call a function in some sheets

  • Thread starter Thread starter henpat
  • Start date Start date
H

henpat

Hello all

I'm creating a code in sheet1, it works fine, but now I need to use the same
code in sheet2 without write again the code.
Also I need to change the name Sheet1 for another name.
In other words, I need a code that can runs in any sheet.

Thanks for your time and sugestions.
henpat
(Excel 2003 SP2)
 
Is it a function in that workbook used in a worksheet? If so, precede with
the book name

='my book.xls'!myFunc()

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Put the code in a Module, not in a sheet. Then you can run it from any
sheet.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Call a function in some sheets 1
EXCEL - IF(IFERROR(VLOOKUP question 0
Excel VBA to move cells to sheet2 based on selection in sheet1 0
VBA Macro - Copying specific data to different sheets in a workbookand linking the InputBox to a com 7
help with a vlookup 2
Sumproduct function allow a lookup for one Date to check if it fallsin Date Range in other table 9
Need a littel excel help 0
moving rows to another sheet 3

Back
Top