with statement

Hi Guys,

I wonder if someone could take the time to help..

I would like to amend this code slightly by forcing it to perform the exact same function on an additional tab called Forecast.

So where the code says With Worksheets("Drill Down") I want it to say With Worksheets("Drill Down") and worksheet Forecast, however I am not having much success!

Maybe it's something like

Worksheets("Drill Down").select
WorkSheets("Forecast").select

Thanks for looking

Please Login or Register  to view this content.

Add the following lines of code to your Dimensions

Please Login or Register  to view this content.

Replace the With Statement with

Please Login or Register  to view this content.

Replace the End With Statement with

Please Login or Register  to view this content.

The minimal change to make to do this operation on two different sheets is to add the worksheet as an argument to your sub, then call it twice. See code highlighted in red. Did I understand the question?

Please Login or Register  to view this content.

may be try:

Please Login or Register  to view this content.

edit: almost the same way ;-) but as always slightly different way to skin the cat.
Notice other type of argument, other way to call procedure with argument and my doubts about serching for value of y - shall it be always taken from Drill Down sheet? Can imagine that it shall do this way. Or shall it be determined as other value for Forecatst sheet - also pausible.

Awesome - many thanks guys for taking the time to help. I appreciate the different solutions! Solved!

Jeff, you did understand!! good to hear from you.