having not found an adequate solution to
http://www.computerhope.com/forum/index.php/topic,85218.0.html and from elsewhere
i am now asking if i can take the text/values from a cell and use them in the VBA macro?
for example i have in cell D4 the text/value "A4"
can a macro take the text from this cell?
i plan to make the cell A4 an activecell, for reasons i wont go into now i cant simply range("a4").select and apply the macro from there, is this possible?