cells

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...

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...

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...

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...

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 =...

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...

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...

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...

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...

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...

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...

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...

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...

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.

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...

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...

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...

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...

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...

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...