View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Peterzh193 Peterzh193 is offline
external usenet poster
 
Posts: 4
Default copy text from a cell to enter in macro

having not found an adequate solution to
http://www.OfficeKB.com/Uwe/Threads/...GP05.phx .gbl



i am now asking if i can take the text/values from a cell and use them in the
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?