When I try to run the program, I get the following message.:
Here is the macro with the part that is highlighted yellow when I click "Debug" underlined.:Run-time error: '438':
Object doesn't support this property or method
What am I doing wrong?
Please Login or Register to view this content.
Any help in getting past this error would be appreciated!
Try this, which is one line of code.
Please Login or Register to view this content.
If posting code please use code tags, see here.
I put
all on one line and, I get a syntax error and, the line's text is coloured red.Please Login or Register to view this content.
Sorry, looks like I wasn't clear.
It is one line already - I've used the line continuation character '_' to spread it over 2 lines to make it readable.
Using the following one-liner is also not working.:
This is the message given.:Please Login or Register to view this content.
Also, what was wrong with that I was doing initially?Run-time error '1004':
Application-defined or object-defined error
The earlier problem was that the Selection was a range and a range doesn't have a Paste method or property.
What similar thing does have a Paste method or property?
Also, what's going on with the syntax you demonstrated?
Not sure what you mean.
Paste can apply to a whole bunch things, you'll find them all in the Object Browser (F2) if you search for Paste.
As for the syntax, there's nothing wrong with it.
The error you describe is a run-time error not a syntax error.
Okay so, the Visual Basic Editor must be making a mistake or something since
is highlighted in yellow when I click "Debug".Please Login or Register to view this content.
Do you any idea what could be happening?
If it was a syntax error the line would be highlighted red, as the code in #3 was, before you even ran the code.
When a line is highlighted yellow when you run the code and hit debug it means it's a run-time error.
One possible problem could be that a variable/variables in that line of code were incorrect.
Can you attach the workbook associated with the code?
Actually, I found the mistake.
The
line was commented out.Please Login or Register to view this content.
I fixed a few other mistakes and now my program's problem is logical (instead of syntax or run-time error related).
Thanks for your help.
So one of the variables was incorrect.
Yes, I realized that the "lastColDest" variable was not initialized which was why I had uncommented it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks