clarify

  1. M

    Range selection VBA

    Hi I'm trying to select a range in VBA (from cell A2 to M2 down to the bottom of the range of data), but the Sub is going to the bottom of column A instead of selecting the range. Can someone please clarify why? I used this code: Sub R1() Range("A2:m2").End(xlDown).Select End Sub
  2. H

    Please clarify me what is the meaning of "><=" in function Instr?

    I am learning about UDF. So I saw a code as below and I didn't understand operators "><=" in that code Chk = (InStr("><=", Left(FindStr, 1)) > 0) Can I help me to clarify it?
  3. P

    Finding the address of a matched cell with VBA

    Hey. I need to change the below cell code into VBA code. =ADDRESS($O$7;MATCH(K7;'3rd exercise'!3:3;0)) Just to clarify, I am trying to remove unnecessary cells from the worksheets, so all the cell references are already variables in the code, except for the '3rd exercise'!3:3 as it is a value...
  4. D

    definitions

    Thanks for the patience over these questions. The answers really are helping me learn. Could someone please clarify why "Monthly is dim as string when the return is a value? Thanks. Dim Monthly as string Monthly = InputBox("Enter your monthly salary:")
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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
Top