macro range value

  1. J

    Macro to copy and paste non-contiguous cell

    I am trying to create a macro to copy only cell in 3 columns that have data. I have the macro working in one of the columns but if I try one to the left or all three in a range it doesn't select properly and am unable to proceed. I use this and it works fine. 'Copy Cost Codes and Qty as Text...
  2. M

    macro - select unknown data range and convert to proper case

    Hi, I have a different excel spreadsheets which I must convert to PROPER case My difficulty is that have two macros that seem work individually and I am wondering how I can combine both and if this is possible. Firstly I am using the following to select the 'range' of values Sub...
  3. K

    Macro variations

    Hello, guys! I've got a couple of issues. There's the line in the macro which goes If Range("C" & CStr(LSearchRow)).Value = "PS MOP" Then If Range("C" & CStr(LSearchRow)).Value = "PG MOP" Then If Range("F" & CStr(LSearchRow)).Value >= DateSerial(2012, 10, 1) Then If Range("F" &...

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