Being somewhat proficient at Excel and suddenly having to write macros in VBA for a rush project, I just got the "Definitive Guide to Excel VBA, 2nd Ed) by Michael Kofler, 2003.
Pretty good, does assume you know Excel. Covers up to Excel 2002. About 1000 pages.
-Pete
VBAjedi:
CHING!
You nailed it on the head with your first suggestion.
Moving the Open/Activate/Unprotect prior to copy worked.
And kept an activate to the destination prior to paste.
Thanks, I spent a couple hours trying things before posting, but missed this.
-Pete
Hello:
I am writing a macro to insert data from one workbook (source) into another workbook comprised of one sheet (target)that is protected. No real previous VBA experience.
In code snippet below, I activate my source worksheet, define my copy range (1st With/End With block) and copy it...
Jojo11
We have some critical legacy auomation systems at my work which use ISA slots. Sine we depend on them heavily, I acquired spare PC's for them in preparation for the worst. Best solution I came up with was to get used motherboards or PC's from the mid to late 90's. They usually have 2-4...
I have had the same issue in registering Roxio. I tried 6 different sensible usernames/passwords to no avail. Basically had to type a bunch of random jibberish to get it to take my username and password.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.