pasting values with vba excel

[masterinex]

on Shee1 , the sheet on which the sub is supposed to run i have this code:

Please Login or Register  to view this content.

i am getting run time error 424 object required.

[kalbasiatka]

Please Login or Register  to view this content.

[6StringJazzer]

masterinex, you are not a new member and should know this by now, but please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires code tags. I have added them for you this time for the sake of keeping thing moving along.

[6StringJazzer]

Because this code is in the worksheet with the data this is all that's required. Just remove the "asdf."

Please Login or Register  to view this content.

[masterinex]

thx for the suggestion , it is working now ...


btw i still don't get where should i run this macro , under modules or sheet 1 and how do i make use of code tags

[6StringJazzer]

I don't understand your question. You said this code was in the sheet with the data, and you said it is working now. Why is there a question about where you should run it?

There are two ways to apply code tags. One is to type them in.

[CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE]

The other way is to select all your code, then press the # button in the formatting panel above the edit window.