How to proceed
 

The below macro works. The only problem is it does only ½ the job. It
currently only works with sheet name "shtVarD". Depending on the user input
another sheet "shtFixD" could be used. The starting point would be different
- but the otherwise the logic is exactly the same...

One solution is to have another "sub" that would do only shtFixD

Another solution would be to "string" items together

A final solution would be create another variable and assign it either
shtFixD or shtVarD.

Or is there a better way?

Any suggestions would greatly be appreciated....




--
Wag more, bark less

How to proceed
 

my suggestion - put your main macro all together under one sub

Sub Main()
.......
End Sub

then have your starting sub:

Sub Start()

if sht.name = shtFixD then
'variable to start wherever
Call Main
end if

if sht.name = shtVarD then
'variable to start wherever
Call Main
end if

End Sub


you get the idea, i imagine. might need some individual tweaking.
hope it helps - somebody else may have a different idea.
:)
susan



On Jun 20, 2:21*pm, Brad wrote:
The below macro works. *The only problem is it does only ½ the job. *It
currently only works with sheet name "shtVarD". *Depending on the user input
another sheet "shtFixD" could be used. *The starting point would be different
- but the otherwise the logic is exactly the same...

One solution is to have another "sub" that would do only shtFixD

Another solution would be to "string" items together

A final solution would be create another variable and assign it either
shtFixD or shtVarD.

Or is there a better way?

Any suggestions would greatly be appreciated....

--
Wag more, bark less