hey folks
i've run across a little challenge today, maybe you could help me out?
the problem is rather simple, i guess:
i have a script which puts values of file 1, cell A into File 2 cell A:
i don't think it is necessary to show the whole code, but the important line is this one
what i want is simply to make it a little bit more user friendly and define A2 in the excel file where i run the macro.
For example, I would like to put the value "A2" into the cell B1. The code should then grab the value of B1 and put it into ws.Range("HERE").
i've tried simple things like
myCell = Range ("B1")
and then ws.myCell = Range("A20") but this didnt work out.
any tips help advices would be very much appreciated
Bookmarks