Need help modifying multiple range code to include LastRow ("B2:B10",..) -> ("B2:B" & LR.)

**sureng20** · 10-09-2017, 05:09 AM

Hi
If I use multiple range selection as ("B2:B1000, G2:G1000, L2:L1000, Q2:Q1000"), the macro works fine. However, when I try to use ("B2:B" & LastRow, "G2:G" & LastRow.....) I get an error on that line. LastRow was correctly defined. I also tried using the Union.

The code will create a list from given ranges in "Sheet2" and write to "Result2" Column A along with a count of duplicates in column B My knowledge in VBA is minimal. Any help is appreciated. Many thanks in advance.
Note: I'm not sure of the original poster of the code, bad of me.

Please Login or Register  to view this content.

**Winon** · 10-09-2017, 05:24 AM

Hello sureng20,

Normally you would get much faster responses if you attach a sample workbook, as we do not usually like to re-event the wheel, so to speak.

Make sure there is just enough data to demonstrate your need.

Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Regards.

**xlnitwit** · 10-09-2017, 05:36 AM

Hi,

You need the commas inside the address string

Please Login or Register  to view this content.

rather than

Please Login or Register  to view this content.

**sureng20** · 10-09-2017, 09:31 AM

Thank you very much, Xinitwit. Placement of the commas made the difference.
Winon, thanks for your suggestion. Next time I'll attach a sample workbook.
Many thanks again.

Need help modifying multiple range code to include LastRow ("B2:B10",..) -> ("B2:B" & LR.)

LinkBack

Thread Tools

Rate This Thread

Display

Need help modifying multiple range code to include LastRow ("B2:B10",..) -> ("B2:B" & LR.)

Re: Need help modifying multiple range code to include LastRow ("B2:B10",..) -> ("B2:B" &

Re: Need help modifying multiple range code to include LastRow ("B2:B10",..) -> ("B2:B" &

Re: Need help modifying multiple range code to include LastRow ("B2:B10",..) -> ("B2:B" &

Thread Information

Users Browsing this Thread

Similar Threads

Budget assist: Entering "Weekly" "Fortnightly" "Monthly" OR "Yearly" with formulas

Using "index", "match", "min", "abs", to find the closest value in multiple criteria

[SOLVED] Column X-Ref list - Sheet1 Col A "pages", Col B:FL "Req" to Sheet2 ColA "req", ColB "page"

Don't know the Forumlas with problem either using "vlookup" "if" "and" or "index" "match"

Pivot Table - How to "add a data column" "of the same field" "across multiple sheets"

Help Needed to get Filters Using "Include" and "Exclude" multiple values on one column.

Macro Error with code "Range("A65536").End(xlUp).EntireRow.Insert"

Bookmarks

Bookmarks

Posting Permissions