CommandButton to copy to new sheet and format

[ruttian]

Hi!

I'm trying to create av CommandButton in sheet "Totalt" and copy range "A8:I200" to sheet "Publisering" and then do some formatting...

But gets "Run-time error '1004'"

I have read that 'copy' from one sheet to another and then performing operations to the new sheet might be a problem. The CommandButton is only working for that spesific sheet (range)... I might be wrong, but need help.

Here is the code:

Please Login or Register  to view this content.

Thanks!

ruttian

[TMS]

Try:

Please Login or Register  to view this content.

Regards

[ruttian]

Thanks a lot!

Just what I wanted! Perfect.

ruttian

[TMS]

You're very welcome. Thanks for the feedback.

[ruttian]

Hi!

I have a follow up question concerning "With - End With"

I'm still trying to perform action on another sheet than where the CommandButton1 is, and I have made some progress...

(My project is a timing system for a cross country skiing club (200+ competitors), and the system has in fact been in use for more than 2 years... But I'm now trying to make the system more efficient and robust).

I have this code (on click it puts the computer system time on the first available cell in column B. The code si good from sheet "Tidreg" but I want to make a registration from sheet "Competitors" without changing sheet...):

Please Login or Register  to view this content.

The first part is ok, but then the syntax (?) is wrong. I hope you see what I'm trying to do...

This is the ok code for sheet "Tidreg":

Please Login or Register  to view this content.

Thanks!

ruttian

[royUK]

The ContactsForm example might help

[ruttian]

Hi royUK!

I guess I could have used some of this for my Macros, but I was just looking for "the simple" solution. I have no idea of how to use variables...
(I have looked into the macro in contacts.xls example...).

ruttian

[ruttian]

PS! For the record, I am an accountant and not a programmer...

ruttian

[romperstomper]

Please Login or Register  to view this content.

[ruttian]

Sometimes I feel so stupid... One simple line of code...

Thanks!

ruttian

[romperstomper]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save