Hi, I have a scenario here but I am not sure how to do it.
I have a spreadsheet here. For example:
The cell 1 value is =$A1$b2 and the cell value for other
cells are other misc formulas similar to cell 1 without
the dollar sign..say example: =B6O5
How can I copy the $ referral sign and paste it to other
cells and made everything into =$X$Y format without
having to manually add it on every cell?

Thanks

Billy

=$A1$B2

returns the error #Name

even if it was a legitimate range reference

=$A1:$B2

also returns an error. (#Value)

What are you really trying to do.

Perhaps you can figure it out on your own by looking at Excel VBA help for
the

Application.ConvertFormula function .

--
Regards,
Tom Ogilvy


"Billy" wrote in message
...
Hi, I have a scenario here but I am not sure how to do it.
I have a spreadsheet here. For example:
The cell 1 value is =$A1$b2 and the cell value for other
cells are other misc formulas similar to cell 1 without
the dollar sign..say example: =B6O5
How can I copy the $ referral sign and paste it to other
cells and made everything into =$X$Y format without
having to manually add it on every cell?

Thanks

Billy