Quote Originally Posted by Johnnydotcom View Post
Unfortunately P45cal your
Set originalactivecell = Activecell
and
OriginalActivecell.activate
does not work
Well, I tested it here before posting.
Perhaps because
Quote Originally Posted by Johnnydotcom View Post
is manually selected by a user
isn't accurate?

Quote Originally Posted by Johnnydotcom View Post
i am using check boxes on a userform to activate the cells
Maybe attach a version of the workbook and userform. There are a number of reasons that part might not work.