1. A

    skip the blank cells

    Hello Excel experts, I use a formula in Sheet2 from B10 to B100 cells. =IF(DATEDIF(Sheet1!C10,Sheet1!$F$9,"Y")>=59,Sheet1!B10,"") i want to skip the blank cells in Sheet. Sheet2 protected only B10 to B100 cells are not protected. Thanks in advance.
  2. W

    VBA: Merge duplicate rows into one row

    Maybe my search words are lacking what they need for me to find the answer, so I need help. I have a table like this, where you can see Mod "a" was duplicated on 2 rows. I was trying to write the code to where if it was matching in column A, pasteall skip blanks, but It's not working for me. Any...
  3. T

    Function arguments

    I have the following If Not Intersect(Target, Range("H7:H37, I7:I37, N7:N37, O7:O37")) Is Nothing Then If Target.Count > 1 Then Exit Sub As in the above example, the range of cells will continue to be 2 columns and then skip 4 columns, 2 columns and then skip 4 columns, etc. This pattern...
  4. earthworm

    Skip Macro with IF Condition

    If i want to skip one macro if the value in cell for example A1 is 0 then move to next macro . How can i do this. I am not sharing any example because i only want to understand the formula construction
  5. S

    Create PO number List skip blank cells

    Existing data is Sheet4!E2:Sheet4!E700 and appears as below: <colgroup><col></colgroup><tbody> Retailers PO 9608561996 blank blank blank blank 5008561749 blank blank blank 4908561680 </tbody> I need to pull it to another sheet (column A) but skip the blank rows. I have...
  6. C

    Skipping Specific Row Within a Loop

    Good day all, I have a quick question: I am running a loop which copies certain cells from rows according to an IF statement from a different worksheet. My code runs from i = 9 to i = 61 but I need it to ignore row 21, as it meets the IF condition yet I still want it to be ignored, how would I...
  7. R

    VBA - This is causing my code to loop and I can't stop it

    NoTours:Resume Skip Skip: ads.Activate ActiveCell.Offset(1, 0).Activate WB.Save For some reason after I hit WB.Save, it goes back to "NoTours" and just goes over and over. Do I need to insert something after the WB.Save to stop it returning to NoTours? Thanks.
  8. M

    Next without For error

    Does anyone know why I would be getting this error? It worked fine before I added 7 additional ranges and 7 additional strings. I've limited the rows to run from 13 to 20 for a test but it worked running 700 lines without an issue before adding ranges and strings to expand to other columns: Sub...
  9. L

    going to next i on certain condition

    Hey guys, i have a piece of code that is throwing an error: next i without for at the NextIteration part For i = 2 To lastRow variableInQuestionReal = Range("L" & i) variableInQuestionDecimal = GetDecimal(Range("L" & i), False) If isError(variableInQuestionReal) = true Then GoTo NextIteration...
  10. D

    Power Query to iqy

    Does anyone know how to connect to an iqy through Power Query? Currently I'm using Power Query to connect to separate Excel file that contains the iqy. I would really like to skip the "middleman" and use Power Query to direct connect to my iqy. Thanks in advance.
  11. P

    Cel.Offset with InStr

    I am trying to not include cells which contain certain strings in my For Each Loop. I have the following: For Each Cel In Rng If Cel.Offset(, -5).InStr(1, Cel.Value, "Part of" Or "NOT REQUIRED" Or "Need breakdown for") Then GoTo Skip 'the -5 is trying to Offset to the left rather than...
  12. J

    I need help with a Conditional Format formula.

    I need a formula to Conditionally Format cells in a column based on a given sequence. In this example, I want to sum the values in Column A until it equals 3 and then cell fill the next 2 values. If possible, I would also like Column B to display "1", or "2" for the number of "highlights" for...
  13. R

    Rank formulas a bit modified

    Hi, i'd like to ask, since this is bit confusing, i don't know how to rank like this case. my goal is to keep the rank in order, not skip it even if there's duplicate. thanks a lot for your help
  14. P

    If Range of columns appears in Rng, Do Things

    I have the following: Sub Automatic_Highlights(Rng As Range) If Rng.Range("O:T") = True Then GoTo Skip ' In my head this should read "If Rng falls within Range("O:T"), Then GoTo Skip"; Or that's how I want it to read at least. Rng.Interior.ColorIndex = 7 Intersect(Rng.EntireRow...
  15. A

    Skip a column and and add - VBA

    Hello, i am trying to do a simple task with VBA but code is not working. I need to add Column N,Q,T.... In other words every 3 column i have the following code For lrow = 7 To 15 For xcol = 14 To 78 Step 3 'sumx = 0 sumx = sumx + Cells(lrow, xcol).Value Next xcol md.Cells(lrow, 79).Value =...
  16. A

    How to skip Worksheet_Change?

    Can I skip/disable a sub code before run my marco then recover it like as following: Private Sub progress() Skip run/disable Sub Worksheet_Change(ByVal Target As Range) My Marco Recover/enable Sub Worksheet_Change(ByVal Target As Range) End Sub
  17. earthworm

    How to skip macro if data in particular cell is empty or zero

    I have written a macro to split a data into separate sheets . If the value in a particular cell example a3 has zero or empty then skip the marco and move to next , but if the value is cell a3 is not empty or value > 0 then run the macro . Please assist.
  18. E

    Unsure how to write a loop which intentially skips particualr rows

    Hi, I've got the below code to behave as expected, but I'd like the loop to skip pre determined rows if its possible. :confused: Sub HidingRowsWhenBlank() Dim r 'row For r = 4 To 62 'skip rows 20 to 31 and rows 41 to 52 If WorksheetFunction.CountA(Range((Cells(r, 3)), (Cells(r...
  19. C

    Cycle through sheet tabs

    I have the following that cycles through sheet tabs but I need it to skip a tab if tab is named "Debt" and then continue to cycle through remaining sheets. If ActiveSheet.Name <> "Data" Then Do Until ActiveSheet.Name = "Data" How do I tell it to skip that tab but continue to reaching the...
  20. A

    Clear Cell Content

    I'm using this code to clear a row (Column A - R), However, I like it to skip column "J"... Can someone assist. Thanks ActiveCell.Resize(, 18).ClearContents

Watch MrExcel Video

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