Try dim ws as worksheet set ws=sheets(results) ws.UsedRange.Offset(1).ClearContents
I get full intellisense that way. Sheets is ambiguous as to what object will be returned (worksheet/chart) so intellisense can't know what properties and methods to suggest to you. However, I would think worksheets(results)....etc. Would work, but it doesn't. If you run in to trouble with intellisense, you'll probably find that assigning the first or second object to a variable declared properly resolves the issue. Asa -----Original Message----- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Domain Admin Sent: Thursday, April 05, 2012 10:01 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ How do you find all the properties or methods of an object? Reading the binding stuff harkens back to days of yore when we had to first compile then separately link the programs and the former gives you the syntax problems and the latter the missing library elements, outside objects, etc. I still though do not know why when I enter ActiveCell.Value = shorttext intellisense comes awake when I enter the period after activecell but when I type Sheets(Results).UsedRange.Offset(1).ClearContents I do not get intellisense help after the period following usedrange. On Thu, Apr 5, 2012 at 9:48 PM, Domain Admin <domainqu...@gmail.com> wrote: > My help already set to offline. Now I see what you mean though. > Instead of looking up usedrange I looked up range which gave me the > list of properties I wanted. > It seems absurd though not to be able to type in usedrange and get all > the associated properties. Trying the object browser again I can find > things through it though it works backwards from the way I would > implement the search hierarchy (actually I would have a switch to look > up or down). > > On Thu, Apr 5, 2012 at 9:32 PM, Asa Rossoff <a...@lovetour.info> wrote: >> ActiveSheet is not the name of an object. It's the name of a property of >> several objects: Application, Window, and Workbook. >> >> >> >> Application is basically a default object, so unqualified ActiveSheet refers >> to Application.ActiveSheet. >> >> >> >> The description for all the Activesheet properties include the words >> "Returns an object that represents the active sheet". >> >> >> >> To find out the properties and methods you can use with ActiveSheet, you >> need to look up the object ActiveSheet returns. What Help didn't say what >> the object returned by ActiveSheet is called. There isn't an object called >> Sheet. The Help for the Sheets object, though, explains that Sheets >> includes Chart and Worksheet objects. To find their properties and methods, >> read the entries for the Chart and Worksheet objects (or use the object >> browser). >> >> >> >> Asa >> >> >> >> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] >> On Behalf Of tangledweb >> Sent: Thursday, April 05, 2012 5:57 PM >> To: excel-macros@googlegroups.com >> Subject: $$Excel-Macros$$ How do you find all the properties or methods of >> an object? >> >> >> >> If I want to find all the properties (if that is the correct word) for an >> object how do I do it? Excel help just gives simple examples. In the ones >> I wanted intellisense did not help. >> >> Right mouse on the word gave an option to list all properties and methods >> but when clicked nothing happened. >> >> >> >> For example, I want to know all the properties of activesheet such as >> usedrange. I want to know all the properties of usedrange such as offset. >> How do you find them and their usage syntax? >> >> -- >> FORUM RULES (986+ members already BANNED for violation) >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will >> not get quick attention or may not be answered. >> >> 2) Don't post a question in the thread of another member. >> >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> >> 4) Acknowledge the responses you receive, good or bad. >> >> 5) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> >> ---------------------------------------------------------------------------- -------------------------- >> To post to this group, send email to excel-macros@googlegroups.com >> >> -- >> FORUM RULES (986+ members already BANNED for violation) >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will >> not get quick attention or may not be answered. >> >> 2) Don't post a question in the thread of another member. >> >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> >> 4) Acknowledge the responses you receive, good or bad. >> >> 5) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> >> ---------------------------------------------------------------------------- -------------------------- >> To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ---------------------------------------------------------------------------- -------------------------- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com
