ws.activate

  1. S

    Excel User form Using VBA : Help on Unique Values.

    Hi Friends, I am stuck with one thing in a User form . I have a dropdown where the data is taking from a sheet. I want only unique values in the droplist. I already have the code , but can someone please help me to edit this code which will give only unique values in the droplist. Note ...
  2. M

    Last Row is selecting an EXTRA 2000 rows.

    So I'm looking to copy a range from a newly created, temporary query sheet to a permanent sheet with the code below. Hitting Control + End on the Query2 sheet brings me to I109, exactly what I would expect. Hovering over the LR variable in the code shows 109. Debug.printing the variable shows...
  3. B

    Copy Data

    Hello All I know this is incorrect , Can someone explain why all my data which meets the criteria <> 4 is not copied to sheet 7. Is the rows(j) the issue Sub CopyNot4Q() Dim lr1 As Long, p As Long Dim ws As Worksheet Set ws = Sheet6...
  4. L

    Count Rows Copied

    I have the below code which works great. After searching this and other forums I can't find a suitable code that will allow me to store the number of rows copied to display in a message box. Thank you for your help! Dim tgtWB As Workbook Dim tgtPath As String Dim ws As Worksheet Dim lr As...

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