visual basic for application excel mac compile error invalid qualifer

Visual Basic For Application Excel Compile Error Invalid Qualifer How To Correctly Use
Visual Basic For Application Excel Compile Error Invalid Qualifer Code Is Also

For a better experience, please enable JavaScript in your browser before proceeding.

The values in my array refer to a cell location within a sheet and my goal is to take the value from that array and select the entire row so i can copypaste onto another sheet.

Visual Basic For Application Excel Compile Error Invalid Qualifer Code Is Also

This is what your code is also suggesting correct Also, on a side note.

I have looked all over the forums but have not been able to find an answer to this seemingly simple question.

My data entries range from columsn D:M only and I originally wanted to just take the cell address from my array and select the pertinent columns to copypaste.

The search function is a user specified search range for a specific property the following code shows essentially how Results1 is filled.

I have attached sample data, i need someone to help me convert the left side to how the data looks on the right.

Unfortunately your post does not comply with Rule 3 of our Forum RULES.

Posting code between CODEPlease url Login or Register url to view this content.CODE tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Click on Edit to open your thread, then highlight your code and click the icon at the top of your post window.

More information about these and other tags can be found here ( This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7).

Every separate macro within your module must start with Sub subname and end with end sub.

And that very first line data dump macro isnt commented out so Excel thinks thats an executable statement.

Visual Basic For Application Excel Compile Error Invalid Qualifer How To Correctly Use

My colleague would normally do this for me, but has inconveniently taken leave today Any help understanding what im doing wrong and how to correctly use (she created the Macro) would be great thanks.

Visual Basic For Application Excel Mac Compile Error Invalid Qualifer