I’m trying to set up a database type program in excel using VBA, you may find yourself asking “why not use access” the answer is the boss wants excel. Believe me every day that I work on this thing I cry, sad…sad little tears :cry:
Anyway I’ve got it all done except one tiny thing. And if you could help me I would be extremely grateful.
I need to copy information form one cell in an active sheet, to another cell in an inactive sheet, without leaving the active sheet.
Here is a snipit of what I’m trying to do. “Not working though”
Rem copy cells form one sheet to another A = Sheet("Final Checklist").Range("F9") If A > 0 Then Sheet("Summary").Range("10B") = Sheet("Final Checklist").Range("B9") End If
If this is the wrong forum please don’t flame me I was just looking for a little help.
P.S. I'm using MS Office 2003, OS Windows XP Pro