vba if statements

  1. T

    VBA filter grand total if blanks, if not skip filter

    Hello, I am trying to edit a macro with some pivot tables. I am extremely novice with VBA editing and I would be extremely appreciative of your help :-). The macro creates a pivot table and grand totals for monthly data. Sometimes the grand total must be adjusted with filters. At times I need...
  2. L

    Help with, if contains text

    Hi, I am after some help with macro, I have multiple macros running and want to add check if statement to check correct data entered, if not stop all macros. -------------- So after a paste If "A1" does not contain specific "text", MsgBox "must contain this xyz", Stop All other subs Else...
  3. J

    VBA code to move data with selected criteria - coding questions

    Hi, I am trying to create some code that will move data from one worksheet to another if it meets a certain criteria.The criteria will be a product category and a week number. If possible the week number will change incrementally and on a weekly basis. For example this week is week number 37...
  4. L

    If statement with upper and lower limit in vba not evaluating correctly

    I'm helping a coworker with a spreadsheet template. Users will enter a type of asset and depending upon the asset type they must enter a number of periods for depreciation that fits within a range. The asset types are entered as the result of a dropdown list so there should be no issues with...

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