Helpful dictionary of VBA syntax

SEARCH

Search for:

TIPS FOR USAGE

Searching for Commands

Start search with
“What is the syntax to …”

Remember to use keywords
(eg) a specific userform control

Reading Command Articles
Blue text – user needs to fill in
Black text – essential syntax
Green text – helpful comments

CREATED BY ANRAN LIU

What is the syntax to access the current sheet?

ActiveSheet

'example
ActiveSheet.Range("A1:A4") = "hello"
ActiveSheet.Range("D1") = "world"
ActiveSheet.Cells(2, 4).Value = "goodbye"

Save this:

Click to email this to a friend (Opens in new window)
Click to print (Opens in new window)

Published by

Freeworkings

www.freeworkings.com View all posts by Freeworkings

Posted on 20162017Author FreeworkingsCategories UncategorizedTags Access, active, activesheet, current, reference, retrieve, selected, sheet, sheets, syntax, use, VBA, worksheet, Worksheets

Previous Previous post: What is the syntax to access the left-most sheet?

Next Next post: What is the syntax to declare a worksheet object?

Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy

Send to Email Address Your Name Your Email Address

Cancel

Post was not sent - check your email addresses!

Email check failed, please try again

Sorry, your blog cannot share posts by email.

Save this:

Related

Published by

Freeworkings