change

  1. S

    Excel Template sending e-mails

    Morning I have been tasked with "fixing" and excel template created by someone else who no longer works for the company. We fill in the template, press a "clicky" then it saves and send the completed template to the client. The issue is that the company images that appeared in the E-mail are...
  2. M

    How to tweak this bit of code

    If Not Intersect(Target, Range("K12:T31")) Is Nothing Then If I want to change the range to K12:Q31 and S12:T31 - what should I do? TIA
  3. T

    Change axis bounds in Excel based on data

    I am creating many line graphs and would like to know of a way to change the vertical axis bound minimum and maximum based on the data itself? For example for set of data, the amounts ranges from 6 million to 12 million while another data set ranges from 3 thousand to 5 thousand. Same graph just...
  4. M

    Comparing Weeks with today and selecting the right column

    Hi All, I am trying to create a column that is basically, giving the variance of this week, to the previous week. I want to make this as automated as possible. An example is below: So in the table there are 5 columns with 5 dates, and I need in the 6th column to have O2-N2, and I need this to...
  5. T

    Conditional Formatting Help

    Hi, I want to change 4-5 cells black if one of the cells contains the work remitted and if that cell is blank change it red. Can anyone help I have tried various ways and can only make the cell with remitted change colour.. Thanks :-0 Toni
  6. S

    VBA Changing interior color based on value of another cell in same row

    Dear All i have a data base and i need to change back ground color of a cell based on value of another cell in the same row. for an example, how to change color of A1 , if C1 got a date value (only type of value)? other types are email and blank. so I need to change 3 different colors...
  7. B

    Change date to month in ACCESS

    I have a Complete Dt column with the date formatted as 10/8/2019 and I need a formula to convert this to the name of the month. Any ideas? I tried this but all I get is January in the column. Format(DatePart("m",[Completed Dt]),"mmmm")
  8. B

    Change reference columns of a chart

    Hi all. I have a spreadsheet with 90+ charts on, and need to change the cell references by 2 columns (i.e. from column G to column E). Is there a quick way to do this without having to go in to each chart manually? I tried recording a macro, but instead of just replacing the G for E it types...
  9. M

    Change how date is converted.

    Hi everyone, first time posting, but I can't seem to find the solution. When I encode 11/3/19 in a cell, when formatted it would show March 11, 2019. I would like it show as November 3, 2019 instead. Is there away to change this. Thank you very much.
  10. E

    Change Coulour if gender is female

    Hi would appreciate any assistance here. I have a cell in sheet Fig 2 that has multiple names. this cell brings names based on a macro from Master_Data sheet. I would like to be able to know who is male and who is female. In Master_Data I have a column which specifies female or male, Column D...
  11. B

    Change background color of all named ranges

    HI, I am trying to loop through all the cells in thisworkbook and change the background color to vbyellow. My code so far is as follows: Sub testdata() Dim nm As Variant For Each nm In ThisWorkbook.Names Range(nm.RefersTo).Interior.Color = vbYellow Next nm End Sub It draws an...
  12. L

    VBA Change Entire Columns with specific header to Value instead of Formulas

    Hello, I need help with a bit of VBA code. I have columns AIFinal01-AIFinal20 throughout my sheet. Each column contains a formula going to the bottom. I need to change that formula to a value for all 20 columns. The columns are not in direct order and their are columns between them. Any help is...
  13. D

    making excel recognize it's 20XX not 19XX

    is there a simple way to do this so that it's not PC dependent ? change the settings within the workbook? rather not use formulas
  14. S

    Sumproduct formulas to exclude specific text/values in count and totals

    Hi, Can't attach the the file to the post as there is no option to do so which I need help with but this is where the file is located: https://trumpexcel.com/excel-leave-tracker/ What I want to change in this file is to include “IN” and “OFF” on the calendar days that employees are working and...
  15. C

    Conditional SUMPRODUCT to also ignore blanks

    Hi, I have the following code which calculates a weighted average: =SUMPRODUCT(--($U$2:$U$1203=AE3),$AB$2:$AB$1203,$C$2:$C$1203)/SUMIF($U$2:$U$1203,AE3,$C$2:$C$1203) It works very well except that I would like it to ignore blank cells in the range $AB$2:$AB$1203 I tried to change it to the...
  16. S

    MouseMove Event : When mouse is outside the edge or border of command button would like to change the background colour of commandbutton

    Hello How is above statement in RED justified with below code as i am stuck and color does not change when the mouse is outside the border or edge of command button Private Sub CommandButton1_MouseMove(ByVal Button As Integer, ByVal Shift As Integer, ByVal x As Single, ByVal y As Single)...
  17. L

    Excel convert time to Custom

    Hi No matter how I enter the time in excel, excel will change the format to Custom (h:00:00 am/pm). Why excel does not change the format of the time I entered to "Time" instead of "Custom" ? <tbody> I entered excel convert custom 1:00:00 am 1:00:00 AM h:mm:ss AM/PM 1 am 1:00 AM h:mm...
  18. J

    Adapt some VBA

    hello I have found this code how do I change the code to only change the selected cells to turn white Cells.Interior.ColorIndex = 0 Cells(A12:AE39).Interior.ColorIndex = 0 I only want it to work on A12:AE39 Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Cells.Count >...
  19. J

    change row colour when cell is selected for ease

    Hello I have a sheet but in struggling to see if I'm on the correct row when im filling it in Can you change the row colour when a cell is selected? ie: if I select any thing between G21:AE21 I can get A21:E21 to change colour But if nothing is selected then don't change anything Hope ive...
  20. V

    Rename part of multiple sheets if it meets my critera

    I already have a script that does most of the mumbo jumbo of what I need, however at the very end of that script, I want to add the part to rename part of some of my sheets to something else I have multiple template sheets and a master sheet within a workbook, those need to remain untouched...

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