View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
JP[_10_] JP[_10_] is offline
external usenet poster
 
Posts: 5
Default Using variable addresses in vba

On Sun, 16 May 2004 18:02:30 GMT, "cucchiaino" wrote:


"JP" ha scritto nel messaggio
.. .
On Sat, 15 May 2004 05:18:30 GMT, "cucchiaino" wrote:

As I don't have access to the file over the weekend, I have to try it
on Monday.
Would this leave a value in the cell C1 or a formula?


Range("C1")=Range("C1")


Also, will I need to change the reference style to R1C1 for this to
work?


No, you won't need it


bye

cucchiaino:

Thanks again, it worked perfectly.