1. sharky12345

    Find cell that does not contain string

    I'm using this to find cells that contain part of a string; If cell.Value = "*(V)*" Then the relevant part being "(V)".....but now I want to reverse it by searching for cells that do not contain that, I've tried the following but it doesn't work; If cell.Value <> "*(V)*" Then Can anyone...
  2. K

    Slow Code

    Hey guys, Private Sub CheckBox13_Click() Application.ScreenUpdating = False Dim cell As Range Dim InputValue As String On Error Resume Next Range("I8,I11,I14,I20,I23,I27,I33").Select If CheckBox13.Value = True Then With Selection.Interior .Pattern = xlSolid...
  3. B

    Changing a SelectionChange range

    I'm using the following routine, but Z only updates when A12:A21 are selected. I need to change this so that A12:A21 change when any within the sheet is selected. Private Sub Worksheet_SelectionChange(ByVal Target As Range) Dim Cell As Range Dim Rng As Range...
  4. P

    for each - tables - vba

    Hi is there a way to do such a trick: Dim cell As Range For Each cell In Range("Table1[col3]") cell.Value = Range("Table1[@col1]") Next cell or is using standard for look a better idea?
  5. A

    Excel Macro with UDF - Sometimes calculates perfectly but sometimes doesn't

    I've attached my VBA Macros and the UDF, I've highlighted in yellow example rows of where the time sometimes calculates perfectly, then other times it just adds a 0 in the cell. I'm really not sure what the issue is. I can also send the file is necessary. Any help would be much appreciated...
  6. P

    Collection - add

    Hi two versions, one works, second one gives: Compile Error, Expected: = 1) CollectionName.Add cell.Value, CStr(cell.Value) 2) CollectionName.Add(cell.Value, CStr(cell.Value)) What is the difference? Why the second one generates an error Thanks
  7. A

    VBA Macro to copy and paste range into adjacent columns until condition is met

    Hi everyone I need a Macro to repeat a copy and paste process until a condition is met. I came up with the following code that works it is just clunky. Need help to make it more efficient. Also i want the program to end when the condition is met not a predetermine number of column ranges...
  8. S

    Macro to apply formulas to columns

    Hello, so I'd need a macro that applies the following formulas to certain columns: (the formulas refer to specific cells and when I use the fill down button they work just fine obviously, but in a Macro it might be better to use RC??) Formula 1: (Remove initial 4 characters of the cell) Starts...
  9. C

    Delete row when linked cell values are empty

    I want my macro to loop through a series of files and, if all the cells B10:F10 in Sheet2 are empty, then delete row 10. I think my problem is that the value in each cell is linked from Sheet1 and the zero for an empty field is hidden (e.g. ='Sheet1'!B22 & ""); I have tried to delete for both...
  10. M

    Coloring a cell based on another cell value using VBA

    I usually work on it until I solve it... googling the heck out of it. But it's been days with this one and I can't just figure out what I am doing wrong. I simply need to change the color cell... if the value of an adjacent cell falls between certain range. (I CANT USE Conditional Formatting...
  11. E

    For Each loop not working

    I'm trying to write a macro that cycles through each cell in a range. I've done this before so I'm not sure why this isn't working? I was getting a type mismatch error on the cell.value line, tried cell.text and got null. Added the Msgbox and it returns the address for the entire range, not...
  12. T

    ActiveWorkbook.SaveAs with vlookup and cell.Value

    Hi im using Split an Excel File in to Many using VBA from Chandoo.org In the SaveAs part how would I change "& cell.Value &" to something like "& vlookup(cell.Value,MyNamedRange,2,0) &" Dim cell As Range Dim curPath As String curPath = ActiveWorkbook.Path & "\" For Each cell In...
  13. C

    For Each cell In rng - not recognising cell value - ?

    Hi there, I cannot seem to get the Excel vba to read the text/string within a cell, to give a specified result, it just ends up going to the 'Case Else' statement? Code: Sub StandardLifeInsuranceInvestmentBondNewStyleXX() Application.ScreenUpdating = False Dim rng As Range Dim cell As Range...

Some videos you may like

This Week's Hot Topics

  • Launch Script When Tab Is Opened
    Hello all! Is there a way to launch a script or message every time a particular tab (DATA1) is selected/opened? I know it can be done when...
  • VBA that can extract words that starts with # and ends with 2021.
    Hi Everyone, I am straggling to in searching for a vba code that will extract a string that starts with # and ends with 2021. The string has no...
  • Date update overflow error ‘6’
    Dear MrExcel community, I have a project search & update & add & delete can do. There are 32 column and 5 of them is date. When I search date...
  • VLOOKUP Formula ?
    Hi i am using this below but i need to return Column C on Detailed_view. You can see ,1 this returns D, but i need to return C before D. I tried...
  • conditional formatting the whole row
    Hello This is a question solved earlier by etaf. But I am getting some problem. I need help to correct the formula as it is not working in some...
  • Vlookup in vba
    Hi, I am new with the VBA, can someone help me, I have made this macro, but the loop across files in a directory runs only in cell G13, and I...

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