select case statement

  1. B

    VBA code for multiple if statements within an Array

    Hi there, Can you guys help me with below code. what I am trying to do is to split the array in column B which is seperated by commas and then look for each items and if the condition statisfies then it should publish something in column C. I have lot of scenarios with combination of both...
  2. S

    Select case is not working after values copied from other worksheets

    Good afternoon, I would like to ask you guys for a help. I am using Application Intersect with Select Case to enable dynamic hiding of selected rows based of inserted value to certain field (the point is to make formular as small as possible for tje user). The code looks like this. I repeat...
  3. A

    Multiple Statement Select Case

    I have been trying to search how to do this and have not come across anything that helps me with what I am trying to accomplish. I have seen select statements with multiple conditions, but not multiple actions. I am trying to replicate a calculation based on if the action is done daily. I am...
  4. B

    VBA Help. Select Case based on worksheet name

    I have three different macros that make various format adjustments. 1) intacct_CMA 2) intacct_events 3) Intacct I'm trying to consolidate the three macros into one by using a Select Case Statement based on the Worksheet names. I would like for: - macro #1 to run on the worksheet named...
  5. bubleanalytics

    VBA Select Case Within Data Series Loop (Colour Each data point in multi-series Bubble Chart)

    Hi. I have a multi-series Bubble Chart (each data point is part of its own data series eg. ActiveChart.FullSeriesCollection(1).Select is first bubble, ActiveChart.FullSeriesCollection(2).Select is second bubble etc.) I want to use a SELECT CASE statement so that a data point is coloured based...

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