I'm looking to write a VBA code to dynamically apply a "list" type data validation constraint to a range of cells. I recorded a macro to try to reverse engineer it to do what I want, and I'm running into trouble. This is my current code:
My problem line is:Please Login or Register to view this content.
I'd like to be able to dynamically assign this range (something like this):Please Login or Register to view this content.
Excel does not like this syntax.Please Login or Register to view this content.
Does anyone know how I can tweak this to allow dynamic range selection for the Formula?
THANKS IN ADVANCE!!!
Bookmarks