Hi. I found a Macro on bitesizebio that Mr. Hengen was nice enough to provide.
I was using it to make a heat map and it was working fine, then one day,
it stopped working and I received the following error: Variable Not Defined (referring to 'rangetocheck')
I tried defining 'rangetocheck' as a range but then I get an error code: Variable not defined (referring to 'cell' in the 'For Each cell In Myrange' line)
Can any one tell me what happened to this macro? And why it worked one day but not the next?
Thanks so much![]()
Please Login or Register to view this content.
Bookmarks