« Previous Thread | Next Thread » Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) Thread

Thanks! Please join our friendly community by clicking the button below - it only takes a few seconds and is totally free. excel vba excel-vba share|improve this question asked Dec 17 '14 at 15:01 mrbela 669724 Try looking here. –TheEngineer Dec 17 '14 at 15:07… –chancea Dec 17

E.g. The comments are property of their posters. Blegos, Sep 8, 2003 #1 Advertisements Dave Ramage Guest Auto list members does not work with the Sheets method (for some reason?) or Worksheets(..) or several other methods. yes | apt-get install --fix-broken Using transistor as switch, why is load always on the collector Why is the 'You talking to me' speech from the movie 'Taxi Driver' so famous?

Results 1 to 3 of 3 LinkBack LinkBack URL About LinkBacks Bookmark & Share Add Thread to del.icio.usTweet this thread Thread Tools Show Printable Version Email this Page… Subscribe to this While Sheet.Item (and Activesheet) returns an Object, there is no ambiguity when you declare something as Worksheet. PS Did you check the references? You'll be able to ask any tech support questions, or chat with the community and help others.

Home Questions Office Help Forum New Posts FAQ Calendar Forum Actions Mark Forums Read Quick Links Today's Posts Ask a Question Excel Microsoft Word PowerPoint Advanced Search Forum Office & Productivity Browse other questions tagged microsoft-excel-2007 vba autocomplete or ask your own question. Intellisense sometimes refuses to show its face with there is a compiler error. I'm not sure if it was like this all the time or am I just thinking stuff up right now, but I'm pretty sure it used to work even when I

All rights reserved. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 Browse other questions tagged excel vba excel-vba or ask your own question. Powered by vBulletin Version 4.2.3 Copyright © 2016 vBulletin Solutions, Inc. PC Review Home Newsgroups > Microsoft Excel > Microsoft Excel Programming > Home Home Quick Links Search Forums Recent Posts Forums Forums Quick Links Search Forums Recent Posts Articles Articles Quick

Hello and welcome to PC Review. weblink Your name or email address: Do you already have an account? It takes just 2 minutes to sign up (and it's free!). nothing happens I mean after "dot" intellisense dosen't show up but if use dim wb as workbook set wb=Activeworkbook wb.

asked 1 year ago viewed 4193 times active 1 year ago Upcoming Events 2016 Community Moderator Election ends in 9 days Linked 2 VBA Excel - What methods/attributes can I use More About Us... I've edited the answer to include it. navigate here you should get the list of properties and methods as required.

Blegos wrote: > > Ok i have a problem with auto list members in Visual > Basic Editor, when i record macro in excel it write me in > module1 a Type Me followed by a dot. My boss asks me to stop writing small functions and do everything in the same loop Atmega328P 8MHz External Clock Pick Randomly Between -1 or 1 My cat sat on my

Share it with others Twitter Linked In Google Reddit StumbleUpon Posting Permissions You may not post new threads You may not post replies You may not post attachments You may not

Why did they look stupid? It will work if you do this: Code: Dim ws As Worksheet Set ws = Sheets("Main") With ws. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the Your cache administrator is webmaster.

Yes, my password is: Forgot your password? For example when I use: Code: Sheets("Main"). LinkBack LinkBack URL About LinkBacks Bookmark & Share Digg this Thread!Add Thread to del.icio.usBookmark in TechnoratiTweet this thread Thread Tools Show Printable Version Display Linear Mode Switch to Hybrid Mode Share it with others Like this thread?

Here is the case when I start lets say Activeworkbook. Because VBA doesn't know what object is behind the Object, it can't give you a list of properties and methods. If you go to the Object Browser (F2) and look up either ActiveSheet or the Item property of the Sheets class, you'll see that they returns an Object data type. Chip Pearson View Public Profile View message headers Find all posts by Chip Pearson Find all threads started by Chip Pearson #5 December 18th 08, 03:39 AM posted to

subscribe Home Register Calendar Today's Posts FAQ Archive © 2001 - 2016. and then press "CTRL+SPACE" wont't show list members. Which security measures make sense for a static web site? The time now is 04:46 PM. - Contact Us - ExcelBanter forum home - FAQ - Links - Privacy Statement - Top Powered by vBulletin Version 3.6.4Copyright ©2000 - 2016, Jelsoft

I ... that dot will cause good things to happen. You will get the completion list when you type the period after Sheet1. subscribe Build Your Own ASP.NET 3.5 Web Site Using C# & VB, 3rd Edition - Free 219 Page Preview!

I need this. A way round this is possibly to set a worksheet object and use that as the auto-complete should work then i.e. All contents Copyright 1998-2016 by MrExcel Consulting. I choose the excel 10 reference,......

Share Share this post on Digg Technorati Twitter Microsoft MVP - Excel Reply With Quote Jun 1st, 2012,01:51 PM #3 Norie Board Regular Join Date Apr 2004 Location Stirling Posts Learn the most practical features and best approaches for ASP.NET.