if condition macro

  1. M

    VBA Hide/Unhide Columns, different/multiple sheets

    I have two sheets, "Operation" and "EHSQ", I want to be able to hide and unhide certain columns on these sheets, I am thinking of using a a shape and assign the macro where the user can press, like Q1, Q2, Q3 etc. So the user hits Q1, if the columns are unhidden, then the macro hides it and vice...
    • Minx_Minxy
    • Thread
    • hide / unhide columns if condition macro multiple sheets vba
    • Replies: 20
    • Forum: Excel Questions
  2. E

    Concatenate 2 column values if conditions met using VBA

    Hi all, I want to concatenate 2 columns if column A is Not blank and column B cells contains the text "Enquiry" which is part of a longer string but will always be present. I want to go down all of Column A and Column B and return result column A but this isn't happening with the code below...
  3. M

    IF Condition for Two Different Scenarios

    Hello Guys, I have two scenarios need to be solve with IF conditions. In my sheet1 I column cells i have a string which consists of alphanumeric and symbols. I am in the process of cleaning up the strings. I cant fix these 2 cases. Please heads up and help. 1st case: If any cell in I column has...
  4. B

    Logical operation based on existing data VBA code

    Hi All Im am trying to write VBA code. I have a excel with 2 sheets named Current trades and opening position and third sheet i have added just for example of output. I want to create code based on following codition. Can anyone help me...It would be really kind. I generally can read...
  5. J

    Simple VBA Macro code modification required...!!!

    I am using the following code to calculate the Balance from the data, Balance = Demand - collection <code> lRowLastDemand = lRow ElseIf bFoundCollection Then bFoundCollection = False If c.Value <> "BALANCE" Then c.EntireRow.Insert lRowLast = lRowLast + 1 Set c =...

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