vba if function

  1. J

    Copy rows if Interior.ColorIndex = 20

    Hello VBA Guru's, Summary: I have here a code the compare Workbook A sheet1 to Workbook B sheet1. If attributes in Workbook A sheet1 column A is found in Workbook B sheet1 column A, then copy the entire row from Workbook A sheet1 and paste to Workbook B sheet1 and saveas new copy. This is all...
  2. T

    VBA Print Conditioning

    Hi folks, I'm currently working on a user form which populates a worksheet and then prints, I am trying to add a question to the user form in which the user must answer correctly for the sheet to print. This is my current code which does not work Private Sub CommandButton1_Click() 'populates...
    • toughie
    • Thread
    • print if prints user vba if function vba print code
    • Replies: 2
    • Forum: Excel Questions
  3. J

    Copy rows to different sheets if sheet name matches with Text of A column Tweak required

    Sub CopyRowDemo() Dim Rw As Long, LstRwRaw As Long, NxtRwDest As Long Application.ScreenUpdating = False LstRwRaw = Sheets("Raw Data").Cells(Rows.Count, "B").End(xlUp).Row For Rw = 3 To LstRwRaw With Sheets(Cells(Rw, "B").Value) If .Range("B6") = "" Then NxtRwDest = 6...
    • Jyotirmaya
    • Thread
    • auto copy&paste copy & paste from sheet copy & paste range in vba vba if function vba macro
    • Replies: 0
    • Forum: Excel Questions
  4. B

    Excel VBA to paste value and not formula

    I am adding the columns helper to my report. Currently the VBA paste the excel formula and I want to change it to paste value instead. How do I change the excel formula to VBA language (bolded lines below)? Appreciate any tips or help or reference. Sub Test_ACode() Dim DateName$, ReportDate$...

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