cells

  1. T

    Counting Text when the cells have formulas that enter the text

    I am trying to count the number of cells with text. I used this formula countif(B5:30,"*"). However in cells B5:B30 I have formulas that will enter the text based on the condition of the formula. Therefore when I use this formula countif(B5:B30,"*") regardless of how my of the cell actually...
  2. A

    Data Validation

    Dear Excel Experts, In first row from Cell C1 to M1 there are name of persons and below 4 rows have specific numbers. I have set in column A all first row name by using data validation list criteria. I want a formula in column B. if a particular name select in cell A2 then at cell B2 shows all 4...
  3. M

    VBA Code to change the font in a block of cells to white

    Hi I'd like to change the colour of the font in column A in specific cells to white, depending on the cells which are populated in column C. I wrote a simple macro which copies data from Sheet 2 to Sheet 1 - please find below the scenario: Sheet 2 has the values 4, 5 and 6 in cells A1, A2...
  4. S

    problems with audit trail

    Hi all I have the code below which should record changes to cells in a worksheet - recording cell, old value, new value, time, date and domain name of person that made changes. It works well, except: 1. the old value is never recorded and just shows a blank. how do I record the old value...
  5. S

    Runtime 1004 Copy Cells

    Hi guys, hope someone can look over my code and let me know what's wrong with this code. Sub CopyNonBlankData() Dim wkbThis As Workbook Dim lngERow As Long Dim lngLRow As Long Dim i As Integer Set wkbThis = ActiveWorkbook lngLRow =...
  6. N

    Autosize Row Height based on Visible cells only

    I am trying to Autosize Row height based on Visible cells only and not the Hidden columns. I have columns that has very long text that I will be hiding and then I am left with extra white space in other cells and extra long worksheet. I tried formatting the Autofit cells Row height but, it...
  7. R

    insert cellls vba

    Hi Guys I have the following code Cells(LR, 28).Value = txtCNum4.Value In my useform txtCNum4 is a text box name Lease Period What i want is when the user enters a number let's say 10. vba inserts 10 cells after Cells(LR, 28) and i also want vba to add a heading month1 to month10 to...
  8. H

    Countif with Criteria only visible cells

    Hello Friends, I am using this formula to count cells if they contain the word DELAY in Cell A1 =COUNTIF(A2:A10,"*"&"Delay"&"*") Here is a sample list From A2 to A10 Delay 25 Days On Time Delay 52 Days Early 12 Days On Time Delay 52 Days Early 12 Days On Time Delay 52 Days I want the...
  9. W

    Using named ranges in Solver VBA

    Hi, I want to run Solver from VBA, and I would like to vary the "ByChange" cells depending on certain conditions in other cells. (This is to minimise the number of ByChange cells, and remove any redundant cells i.e. ones that definitely will have no effect on the target cell). This means that...
  10. F

    VBA send email to 3 addresses in 3 different cells

    I have a code that sends an email with attachment. Each attachment needs to go to 3 different addresses which are in 3 different cells. I can get it to send to the address in column K, but I need it to also send to L and M. Here is the code I have so far. I'm not sure how to add multiple...
  11. V

    Code/VBA pls

    We have the following sheet Excel 2010 32 bit ABCDEF 11224205218230218 2211210610094105 335158594649 442224222727 55111212129 6681010812 7722201 8803133 9911 10102 1111 1212 1313 1414 1515 1616 Sheet: Sheet1 now we want to check the cells A1:F16, which coloumn...
  12. E

    Data Validation Circles Blank Cells Even With 'Ignore Blanks' checked

    I have a large spreadsheet that I have pasted values into from another worksheet (I literally used 'paste values' from the context menu). The sheet I'm pasting into is set up with drop down menus that the data i'm pasting needs to match. I am attempting to us data validation circles to find the...
  13. E

    Data Validation Circles Blank Cells

    I have a large spreadsheet that I have pasted values into from another worksheet (I literally used 'paste values' from the context menu). The sheet I'm pasting into is set up with drop down menus that the data i'm pasting needs to match. I am attempting to us data validation circles to find...
  14. T

    VBA or Macro to stop workbook save

    Hi, I'm new to VBA / Macro and need your help on how to prevent the Excel workbook from saving if any cell(s) in a column has a FALSE result from the formula executed in those cells. The workbook can only be saved if all the cells in this column have TRUE result. Thank you for your assistance.
  15. R

    How do I copy a formula to multiple cells and only change one reference cell but not others?

    I am trying to copy the following formula that has multiple If Statements referencing multiple other cells for the desired results and only the first cell referenced but not the follow 3 cells referenced in the desired results. =IF(A2=1,'Team 1'!B13,IF(A2=2,'Team 2'!B13,IF(A2=3,'Team 3'!B13...
  16. C

    Counting with blank cells

    Hi everyone, I have a formula like this in cell E14: =IF(COUNT(C14:D14)=2,(D14-C14)*24,"") which is checking that there are numbers in both cells, if yes find the difference, if no leave blank. This formula repeats a number of times along a row with different cells referenced. At the end of...
  17. J

    Creating an Unusual List

    My problem is the following: I am looking to create a list in 'column A' by referencing a range of cells from the range B2:E20 with some blank cells and some not. In the list I want to include only the non-blank cells while also updating automatically if the cells in 'columns B:E' are changed...
  18. T

    Only Run Formula on Cells in The Table.

    Hi all! When I open my excel book it takes forever to open due to poor coding on my part. I have a bunch of codes like the below code. What I want is instead of E:E which I believe is why it takes so long to open I only want it to check cells in the actual table or until it hits a blank. I...
  19. Beatrice

    VBA - copy&Paste value without formulas

    Hi, I am using Excel version 2007, i m very new to VBA, please help. --quote-- Windows("Template.xlsm").Activate Sheets("SUMMARY").Select Range("A1:T52").Select Selection.Copy Windows("Destination File.xlsx").Activate Sheets("COPY OF SUMMARY").Select...
  20. Dan Wilson

    Locking cells containing formulas

    Good day. I am running Excel 2013 out of Office 365 on Windows 10 Home. I have created a rather extensive workbook containing seven worksheets and twenty Macros. Each worksheet has cells that allow the user to enter data. The other cells contain formulas. I want to make this workbook...

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