lastline

  1. B

    Correct Search String syntax for exact integer match, not all matches

    New to VBA, so have searched and borrowed code and ideas from anywhere without really understanding yet what's going on. What is the correct String search syntax to find an exact integer match in a column rather than returning all numbers containing the integer ? That is, if I search for "3"...
  2. D

    XPS Automate file save as

    This .XPS bloc works perfectly, but is currently running a manual save feature to the end user. I've tried everything in my knowledge base and a several hours on the net. I prefer to automate the save function and nest it with the balance of the wb dir files. Any ideas greatly appreciated...
  3. W

    Select entire Column till last row VBA

    I feel this is very simple fix but my code is flawed. Dim LastRow As Long With Worksheets("Sample") LastRow = Cells(Rows.Count, "A").End(xlUp).Row Range("R2:LastRow").Select End With

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