cell reference formatting

  1. S

    Cell referencing

    I need to hide and unhide the shapes located in din different worksheet based on a cell value which is in other sheet. For example cell H6 is in the sheet 1 in which the code is written and shapes are in the MassBalanceLSFO sheet. Both are in single file. Thanks in advance. Private Sub...
  2. J

    Cell reference character limit

    Working on an uploadable spreadsheet that translates info entered on one sheet to another. The comments field column on sheet 2 is formulated as =TEXT('Sheet1'!CellX, "") The comments are being referenced, but there seems to be a character limit, as longer ones are generating a #VALUE! error...
  3. K

    Problem with Conditional Formatting and global cell references

    Hi! I have a problem with "global" cell references and named formulas when used with conditional formatting. I have several sheets where I use conditional formatting to highlight cells where a cell is empty. I use the same formula for several sheets, so I thought it would be a good idea to use...
  4. G

    Column Labels are Numbers Not Letters...

    I am using Excel 2007. Today when I opened up Excel, I noticed the formulas being automatically created from my actions were a little strange. Then I noticed the columns weren't labeled with letters instead each column was labeled with a number. So cell A1 is now R1C1. Not sure how this...

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