Paul The Programmer

60 Second Blog

« Back to 60 Second Blog « Older Entry | Newer Entry »

How not to make it easy

Posted at 10:37 AM on December 22, 2008

Ahhhh...

OK, so I've got a VBA form. It got an office web components spreadsheet (version 11 point something or other)on it. Tried for over an hour just to get access to cell A1. In case your also wrestling with this 'mamoth' topic, here's how you do it.

Spreadsheet1.Sheets("Data").Select
Spreadsheet1.ActiveSheet.Cells(1, 1).Value = "Bobs your uncle and Fannys your aunt"

No idea why that took me so long, hope it help someone else out there.

Categories: VBA (or how to go insane)

0 Comments

Dont Miss a thing.

Get FREE updates from me by email. Get a mini profile that lives on my website. Learn and teach. Communicate and share ideas with other members. Join here.