Originally Posted by Johnnydotcom Unfortunately P45cal your Set originalactivecell = Activecell and OriginalActivecell.activate does not work Well, I tested it here before posting. Perhaps because Originally Posted by Johnnydotcom is manually selected by a user isn't accurate? Originally Posted by Johnnydotcom 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.
Set originalactivecell = Activecell
OriginalActivecell.activate
p45cal Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.
View Tag Cloud
Forum Rules