alter

  1. reasem

    Want conditional formatting to reset after column filters are used

    Using the formula=MOD(ROW(),2)=1 to have every other row have color to make it easier to use a large spreadsheet I have. When I change the column filters the rows are no longer colored every other row obviously. Can I alter the formula at all to have it reset when filters are added? somehow use...
  2. H

    Alter Formula for unique value to sum only visible cells

    Hello Friends, I am using this formula to count unique values in a range =SUM(IF(FREQUENCY(IF(LEN(orders_ref)>0,MATCH(orders_ref,orders_ref,0),""),IF(LEN(orders_ref)>0,MATCH(orders_ref,orders_ref,0),""))>0,1)) I want this formula to count only visible cells.... If anyone can provide a...
  3. John Caines

    alter sub to clear cells within a range

    Hello All. I very kindly maanaged to get a 'Clear Cells' sub from the board. (Thank you Fluff!) :-) The sub code is below; Sub ResetCells() With Selection .Font.Name = "Ariel" .Interior.Color = xlNone .Font.Color = vbBlack .ClearContents End With End Sub Is there...
  4. Jambi46n2

    VBA Saving Filename with YYYY + 1

    The Code Below Saves the File as "2019 Rate Volume - 2018-08-21.xlsx" I would like to have it saved like this "2019 Rate Volume - 2019-08-21.xlsx" How is the best way for me to go about this? Thank you in advance. 'Date Save Update Definitions MonthPath = Format(Month(Date), "00") & "...
  5. M

    restrict worksheet columns

    Hi, I am looking at a spreadsheet provided by a colleague. It appears to have restricted the column's viewable. So I can only scroll over to column AH, and then it just ends. This must be a setting, it is not like the extra columns are hidden. Does anyone know how to alter these settings...
  6. L

    Have to alter existing sheet but can't find cells to alter.

    Hi all, Just to start, I'm not an Excel expert and just have basic skills. The situation is that i have an existing Excel sheet that was created a couple of years ago by another person who is no longer available. At a basic level, the section i want to alter has a box in which you input a...
  7. S

    Changing the format/layout of an excel worksheet

    I have a worksheet with over 3 months worth of data entry. My coworker claims she can't understand the layout. She wants me to change it from example 1 to example 2. Is there any easy way to do this without re-entering 3 months worth of work? Example 1 <tbody> WK# Date Accnt Name 1 7/9/15...
  8. R

    replacing/altering certain parts of a string

    Excel/VBA gurus: I have a very long column of strings that looks like this: . A 1 one num 1.23 JUL27/09 2 three num 2.34 NOV8/10 3 five num 2.59 DEC10/10 4 seven num 3.90 JAN1/11 I want to alter the first word (one, three, five..etc), based on the following reference array...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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