Running Macro

Mar 8th, 2002, 07:56 AM

Question:
I have a macro that search the data of the worksheet. I am trying to do the search on more the one worksheets in a workbook at the same time. So, I selected all the worksheets before I run the macro. However, it only searchs the opened worksheet but not the others.
So is there a way to solve this problem?
Please help
Thanks in advance

Barrie Davidson · Mar 8th, 2002, 08:17 AM

Quote:

On 2002-03-08 06:56, Anonymous wrote:
Question:
I have a macro that search the data of the worksheet. I am trying to do the search on more the one worksheets in a workbook at the same time. So, I selected all the worksheets before I run the macro. However, it only searchs the opened worksheet but not the others.
So is there a way to solve this problem?
Please help
Thanks in advance

What problems did you encounter when implementing Pierre's solution at

http://www.mrexcel.com/board/viewtop...1669&forum=2&2

I tested his code and it worked fine for me. Please post your code and I'll see if I can help.

Regards,

Mar 8th, 2002, 08:21 AM

I put the following code in ThisWorkBook(isn't it)?

Sub SearchAllSheets()
For Each Worksheet In Worksheets
Sheets(Worksheet.Name).Select
Call Main
Next Worksheet
End Sub

Mar 8th, 2002, 08:28 AM

Oh I think I run the wrong macro
But when I run the correct macro it asks me for inputting the value for each sheet. So I need to enter the value 4 times if I have 4 sheets.
So is it possible that I only have to enter once and the macro can search all the sheets at the same time?

Thanks in advance

Barrie Davidson · Mar 8th, 2002, 08:29 AM

Quote:

On 2002-03-08 07:21, Anonymous wrote:
I put the following code in ThisWorkBook(isn't it)?

Sub SearchAllSheets()
For Each Worksheet In Worksheets
Sheets(Worksheet.Name).Select
Call Main
Next Worksheet
End Sub

What happens when you run the "SearchAllSheets" macro? What spreadsheet is your "Main" macro located? The same as "SearchAllSheets"? Can you also post your "Main" code?

Regards,

Mar 8th, 2002, 08:32 AM

Quote:

On 2002-03-08 07:28, Anonymous wrote:
Oh I think I run the wrong macro
But when I run the correct macro it asks me for inputting the value for each sheet. So I need to enter the value 4 times if I have 4 sheets.
So is it possible that I only have to enter once and the macro can search all the sheets at the same time?

Thanks in advance

Yes I run the wrong macro. I am so stupid
So, is there a way to search once and run on all the sheets at the same time?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 8th, 2002, 07:56 AM	#1
Guest Posts: n/a	Question: I have a macro that search the data of the worksheet. I am trying to do the search on more the one worksheets in a workbook at the same time. So, I selected all the worksheets before I run the macro. However, it only searchs the opened worksheet but not the others. So is there a way to solve this problem? Please help Thanks in advance

Mar 8th, 2002, 08:21 AM	#3
Guest Posts: n/a	I put the following code in ThisWorkBook(isn't it)? Sub SearchAllSheets() For Each Worksheet In Worksheets Sheets(Worksheet.Name).Select Call Main Next Worksheet End Sub

Mar 8th, 2002, 08:28 AM	#4
Guest Posts: n/a	Oh I think I run the wrong macro But when I run the correct macro it asks me for inputting the value for each sheet. So I need to enter the value 4 times if I have 4 sheets. So is it possible that I only have to enter once and the macro can search all the sheets at the same time? Thanks in advance