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
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?
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...
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:")
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.