View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
GS[_6_] GS[_6_] is offline
external usenet poster
 
Posts: 1,182
Default Preserving Cell Values for Comparison

Thank you. I'll give it a shot.

Do you think it might also be a good idea to Dimension any variables
used as "Static"?


If you mean declaring variable type, this is mandatory Best Practice and so you
should check the option 'Require Variable Declaration' on the Options General
tab in the VBA IDE! This will 'force' you to explicitly Define variables and
obviate implicitly using variables altogether!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion