cellref

  1. J

    VBA reference active cell

    Want to add a reference to the cellrange of the active cell. This code debugs... sub cellref() dim ac as range ac = activecell.name end sub
  2. S

    Conditional Formatting removal

    Hi everyone I am having difficulties using some code I got on a a thread to replce conditional formatting with the result of the conditional formatting, I needed to use this as leaving the formatting in place was draining the resources on my laptop. The code I found did work and I managed to get...
  3. B

    Excel VBA Solver Looping Multiple Columns but not updating References

    Dear All, The VBA code runs but Solver references doesn't update properly. In Col I Solver only remembers Col Q references plus Range(H92:Q92) doesn't zero out. <title>Excel Jeanie HTML</title>******> <!-- ######### Start Created Html Code To Copy ########## --> RES Var...
  4. pedie

    Cell referencing error, need help. Thank you

    a1 = datas!a7 when sheet datas, a7 has no value it show 0. can we eliminate this and show nothing when sheet datas, a7 has no value??? Thanks again!;)

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top