vb.

  1. M

    VBA to open & centre comment on cell selection

    hi, The current code i have to make this work is as follows, but it is clunky and causing the worksheet to be incredibly slow. Any ideas if i can achieve the same outcome in a simpler way? I want column H to have cells that i can click and a comment box will instantly open up in the centre...
  2. L

    Run-time error '1004':

    Hello All, I have a problem with a macro below as it returns Run-time error '1004': Method 'Range' of object '_Global failed. I have identical macro where if cell.value 2,3,4,5 etc. works perfectly but not the one below. Worksheet is not locked and scroll area is not limited in any way as...
  3. L

    Changing the range of a named range (special)

    Hi All, I need for my project the following: My range has to have always 1500 rows down from from a specific cell that is described by a value in cell B1. I have a named range called Myrange with this area covered $A$1:$A$1500 and in a cell B1 I have value 1000 and I need a code that changes...
  4. O

    Excel VBA sort entire Sheet with 3 keys

    Hi, i'm having trouble when running a Macro to: - select my sheet (called SFDC) - select all data - sort all data ascendant using columns Account Name then Community then Status Thanks

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
Back
Top