implement what you just wrote".
>
> What I wrote was a stand-alone "sub".
> Normally, I would put it in a Module.
> Then, to run it from your button, change the click event to:
>
> Private Sub CommandButton1_Click()
> Btn_Copy
> End Sub
>
> What you
ent to:
Private Sub CommandButton1_Click()
Btn_Copy
End Sub
What you did by recording the macro and modifying it is a VERY good start.
But to speed things up and to keep the screen from jumping back and forth...
THAT's what makes the macros look GOOD
hope this helps.
Paul
- O
Hi Paul, Thanks so much! It's astonishing to me that this constitutes
a "quick" macro for you!
I guess to answer your questions... I'm using Excel 2007, and
shamefully, I really don't know how to write macros... I did come up
with the script below though it's in conflict with your warning
again
You have not mentioned any bracket, coma etc anywhere in the code...
Like
if(sheet1.cells(3,39))="4" then
you need to write the code in correct format first.
To lock the cell you can have the following code
Cells.Select
Selection.Locked = True
Regards,
Tariq Kamal
www.gate2quality.com
On
Not sure how much help you're looking for.
You said that you "don't know the VB language".
Does that mean that you don't know how to use the VB editor?
do you know how to write a macro?
Can you create your command button and assign a macro?
What version of Excel are you using? It won't matter for
