for statement

  1. T

    Copying Range From Specific Sheets into Different Specific Sheets in Another Workbook with Nested For Next

    First Time Post Here. I have two Workbooks one with daily data for the Month and one with shift data for the Month. Each of these workbooks has summation tabs at the beginning and end of the workbook. The ranges are not the same in the workbooks and there are twice as many sheets to copy to. The...
  2. andrewb90

    Error with FOR/IF statement

    Hello all, I know I have an issue with the statement, but I'm not entirely sure how to correct it. Any guidance would be greatly appreciated. Dim r As Long For r = 4 To 50 If r <> 6 And r <> 45 Then If Range("C" & r).Value = "Front" Then Range("C" & r: "G" &...
  3. I

    VBA - Help - Count visible cells between range [Autofilter/For/If/VisibleCells]

    Hi, Pretty much I'm attempting to count visible cells (after an autofilter) which exist between two amounts to find the total count for that region. Sec6Tot = the count Sec6Test = row for visible data CurrentSett(9,1) = Lower limit CurrentSett(10,1) = Upper Limit This line is currently the...
  4. W

    Sending Emails Via Excel

    Hi All, I want send the a spreadsheet to several email participants. Currently I set the macro to send to just one person how can I build the macro to span the entire list. With OutMail .to = Range("I2").Text .CC = Range("J2").Text .BCC = "" .Subject = Range("L2").Value .Body = "Hi there"...

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