How to proceed

[Brad]

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....

 

[Susan]

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