View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] Johndagolfer@gmail.com is offline
external usenet poster
 
Posts: 6
Default HELP replacing cell references in equations with $X$Y format

Hi all,

Let me explain what I am trying to do.

I am trying to create a form where data can be input horizontally on
one worksheet of a document and then transposed automatically to
columns on a seperate worksheet within the same document.

I am on a short time line so I have to be able to do this quickly.

What I tried to do was copy over the reference to each cell but got a
REF error. After reading a few posts I found that the references
needed to be in a $x$y format for this to work. I have unfortunately
255 x 30 cells to change and would take quite some time to do this.

I am not very good at macros yet so I was wondering how would I be
able to make this change quickly?

Thanks,

John