Copy referral $ sign to other cells.

  • Thread starter Thread starter Billy
  • Start date Start date
B

Billy

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 .
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy referral $ sign to other cells 5
Altered pasting functionality 3
If cell contatin string like .... copy in Offset mode 2
Create if partial match then copy and paste data from one cell to another 1
Copy Cells Q 3
Copying a Picture From Cell Comment 0
Excel Msgbox runing beyond posted cell range. 1
Excel In Excel how can I block the contenent of a cell? 0

Back
Top