Cleanup (addendum) - looking to clean this up

[CNE5x]

Similar to an earlier post, other priorities came up, now looking to resolve this issue again.
Thanks for the assistance

Please Login or Register  to view this content.

[wallyeye]

You could switch from .activate to .row/.col

lngRow = cells.find(...).row -1
lngCol = cells.find(...).col -1

Then your range statement would look like:

Please Login or Register  to view this content.

[wallyeye]

removed per moderator request

[CNE5x]

Please Login or Register  to view this content.

My apologies to all for posting incorrectly
(Result to first find is A36061 need to subtract 1 row - (value should be A36060))

(Result to second find CQ1 need to subtract 1 column - (value should be CP1))

(Always will start from A5 (Value here should be from above finds -1 (CP36060))