Hi Jason,
Almost there, as in, it runs if the Macro is applicable on the sheet it is called from, but gives a Run Time error '1004' Application defined or Object Defined error, and highlights the Rows:
if I change the value
to
and call the code from Sheet1
Seems I have to define a variable but not sure what or how.
If I remove the dot before .Range and change the formula to
it goes back to working only on the sheet that is currently active.
Could you please be kind enough to check the sample file I am attaching for you to check with your code.
Regards,
Naira
Bookmarks