Help with DIM statement

[narrowgate88]

I have this code, and I've declared LastRow() as Long, but it gives a compile error expected array notice on the

Please Login or Register  to view this content.

line. I don't know what it needs to be instead.

Please Login or Register  to view this content.

[MrShorty]

The parentheses () tell VBA that you intend to use lastrow as an array of longs. You do not specify the size (how many elements) this array should use. VBA expects that, sometime before using lastrow(), you will specify the number of elements using a Redim statement.

Your use of lastrow() in the 3rd statement looks more like you want to treat lastrow() as a function procedure. You will give the function a worksheet and it will figure out what the lastrow is. A variable is not a function, so you first need to decide how you really want to use lastrow(), then amend your code to reflect the desired use of lastrow().

[narrowgate88]

I'm just attempting to identify the last row of data in the DestSh worksheet. I originally had the DIM statement without the () but got the same error. Do I need to use something instead of "Long"?

[JOHN H. DAVIS]

I found some things and I highlighted them in Red. Let us know what your objective is a perhaps we can help.

Please Login or Register  to view this content.

[narrowgate88]

Here is the entire code. I'm basically trying to consolidate the data from multiple worksheets onto a summary worksheet. I found most of this code online, so I'm trying to work through the bugs.

Please Login or Register  to view this content.

End Sub

[JOHN H. DAVIS]

Test this on a copy of your workbook too see if it does what you require.

Please Login or Register  to view this content.

[narrowgate88]

Yes, this works. Wow, much shorter. Thank you.

[JOHN H. DAVIS]

You're welcome. Glad to help out and thanks for the feedback.