rangeb2

  1. 3

    Column Clearing Coding

    Good Day people, I was practicing some VBA questions and had hit a roadblock in the coding. The question was asking me to calculate distance between two points. My Goal was to clear the previously obtained value. However, the whole excel sheet got cleared. Here's the coding If (Range("A2") <>...
  2. F

    Use cell value as new worksheet's name

    Hi, I am new to VBA. I would like to name the sheet in new workbook as Range("B2"). However, Range("B2") refers back to the B2 in original sheet instead of the new worksheet. The problem is when I apply filter for column B in original sheet and copy data to new worksheet, for example, the...
  3. M

    Closest Value in a array

    Good day to all, I have a set of fix variables Dim arr1 = Array [{1, 2000,3000,.....}] and was looking for the closest value, so when i input a certain number in Range("A1"), the closest value will appear in Range("B2") for example. vlookup works but was trying to learn coding and stuffs so...

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