cwdth

  1. T

    Edit this code so it only work on a set range not entire sheet

    Hi Everyone, I have this code which is brilliant at dealling with row height on megred cells. however its set up to do the entire page. I just want it to work on range(C34:F34) how can I edit it? thanks Tony Private Sub Worksheet_Change(ByVal Target As Range) 'If...
  2. F

    Code to Auto-Format Row Height of Merged Cells ALMOST Working

    Hi! Thank you so much to everyone on all of these forums! I've amazed myself with what I've been able to do with the help of Google and all the great people that reply to these posts. I'm almost complete with a project that I'm working and stuck on one thing. I have some merged cells with...
  3. G

    Unprotected cells seem to randomly lock - help me solve the mystery please

    Ok. This is a mystery at least to me. I have some code that does three things: It hides certain rows depending on choices made in one specific cell It auto expands rows to accommodate text even in merged cells and It sends a warning when a calculated cell exceeds 100% All of these functions...
  4. G

    Error message when hiding rows in a protected worksheet

    Hi, I have form that has VBA code in it that: allows users to make a selection which determines which rows they see, calculates when a certain cell has a total of more than 100% and resizes rows depending on text entered. All three work perfectly. The problem arises when I try to protect the...

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