Creating a macro to copy from one sheet to another

Discuss the spreadsheet application
Post Reply
soaring_eagle
Posts: 47
Joined: Fri Dec 14, 2007 8:05 pm

Creating a macro to copy from one sheet to another

Post by soaring_eagle »

Hi!

I'm using Vista, and Oo 2.3.0. I'm trying to create a macro to copy numbers from one sheet to another, but these numbers have already been created from another macro. This works fine when i'm doing it myself, but the cell it's copied to when i use a macro is never on the correct sheet. How can i get around this?

Thanks,

:)
User avatar
probe1
Volunteer
Posts: 277
Joined: Mon Oct 08, 2007 1:34 am
Location: Chonburi Thailand

Re: Creating a macro to copy from one sheet to another

Post by probe1 »

Please show us your code - so we don't have to guess what's wrong; TIA.
Cheers
Winfried

DateTime2 extension: insert date, time or timestamp, formatted to your needs
Post Reply