Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Richard Winston wrote in news:o7Uyb.1155609$be.166508
@news.easynews.com: "John Wilson" wrote in : Richard, Why don't I have Excel VBA specific help info There is no such thing. VBA is Visual Basic for Applications. Excel is one of those "Applications" your syntax error. Your VBA Tools/Options are probably set to "Require Variable Declaration" (which is a very good idea). Having this option selected will place Option Explicit at the top of every module (which means that all your variables will have to be declared or you'll get an error). I don't know what code Don gave you, but if you delete that top line (Option Explicit), it should work. Better though would be to find what variables that Don was using in the code he gave you and declare them with a Dim statement. John Why don't I get context sensitive help for Excel objects. When I write Outlook macros I am able to hilight "MailItem", for example, and get help for that particular object. It's not working for me with the Excel Macro that Don gave me (posted below) Never mind, you were right. Now that I did what you suggested and got rid of the Option Explicit, the code works and the context sensitive help works. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
i deleted info in excel then saved. can i recover deleted info? | Excel Discussion (Misc queries) | |||
Move cell info and info in range of cells on new entry | Excel Discussion (Misc queries) | |||
Copied info from Excel worksheet, but pasted info won't work in fo | Excel Discussion (Misc queries) | |||
Can I lock info in Excel 2003 and users in Excel 2000 enter info? | Excel Discussion (Misc queries) | |||
how do i get excel to see info in one cell, look at info in anoth. | Excel Discussion (Misc queries) |