A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Post New Thread
Threads in Forum : Excel Programming Forum Tools Search this Forum Feed Icon
  Rating Thread / Thread Starter Last Post Reverse Sort Order Replies Views
Screen is flashing when VBA adding objects into Excel sheet? by Don Guillett[_4_]
application.screenupdating=false reset to =true at end of macro -- Don Guillett SalesAid Software Granite Shoals, TX "d" >...
July 8th 03 03:01 PM
by Don Guillett[_4_] Go to last post
0 378
Ah, I think... by jonas
Hi, yes it works much faster although It seems like the whole application is shutting down and then reopens (which I am not sure it is actually doing). But...
July 8th 03 03:00 PM
by jonas Go to last post
0 323
Iterating through row cells on column Match, help please. by FrankBooth
Now getting a 2024, Type Mismatch error in this line: res = Application.Match(vName, xlRng2, 0) There is a match for the first name that is picked up on the...
July 8th 03 03:00 PM
by FrankBooth Go to last post
0 377
Ah, I think... by Arne[_2_]
Hmm, the statement Application.WindowState = xlMinimized did not result in all windows getting minimized. The following does minimize all Excel workbook...
July 8th 03 02:51 PM
by Arne[_2_] Go to last post
0 386
Question: Macro overloading, passing variable number of arguments by Frederik Romanov
Excel-97 (SR-2) In general I would like to write macros that can be overloaded, for example Hyperlink() has an optional displaytext field. HyperLink(...
July 8th 03 02:51 PM
by Tom Ogilvy Go to last post
1 522
Accessing the VBA project object model by Tom Ogilvy
http://www.cpearson.com/excel/vbe.htm discusses working with the VBE/VBA with code. You would establish an application.object, Workbook object and from that...
July 8th 03 02:47 PM
by Tom Ogilvy Go to last post
0 575
Can we write VBA code to set all column/row's size back to default size? by Earle
Somthing like one of these may work... a. Worksheets("Sheet1").Range("A1:D8"). _ AutoFormat Format:=xlRangeAutoFormatClassic1 b. ...
July 8th 03 02:46 PM
by Earle Go to last post
0 520
Before Send by Tom Ogilvy
If you replaced it with your own button and tied a macro to it. Regards, Tom Ogilvy "Richard" > wrote in...
July 8th 03 02:41 PM
by Tom Ogilvy Go to last post
0 375
Extracting Access data by Tom Brooks
Tom, Here is one of my procedures in which this problem occurs: Sub BDF1() Set Point = Sheets("Extract").Range("AW1") mycode =...
July 8th 03 02:41 PM
by Tom Brooks Go to last post
0 469
User defined functions - text for formula palette by Tom Ogilvy
Public function MyFunction(arg1, arg2) End Function placed in a standard module (not a worksheet or thisworkbook module or class module) in an open...
July 8th 03 02:35 PM
by Tom Ogilvy Go to last post
0 545
Excel Add-in path in UNC format by Steve Culhane [MS]
Ron, I left a message on two of your other threads, that addressed this, but wanted to make sure you get it here too. I have also added a couple of...
July 8th 03 02:35 PM
by Steve Culhane [MS] Go to last post
0 597
Time based macro by Jan[_6_]
Lorenzo, Check-out the "ontime" method of the application object grtz >-----Original Message----- >Hello - I really hope you can help: I work for a bank...
July 8th 03 02:31 PM
by Jan[_6_] Go to last post
0 662
Question: OPEN return status by Frederik Romanov
Excel-97 (SR-2) My Excel version 4 manual describes the obsolete form of Fopen, with this syntax I hoped to perform = <within a macro> isNA(...
July 8th 03 12:40 PM
by Frederik Romanov Go to last post
0 513
Chart Date Label Problem - Is this a bug in Excel? by brencam
I've created a chart with a 3 data series - one of which I am using as a dummy X axis (using categories, rather than values). The chart is XY scatter...
July 8th 03 05:07 AM
by Jon Peltier[_3_] Go to last post
1 655
[Excel XP] Orientation of cells etc. by Jesper Stocholm
I have to copy the contents of some cells from an external spreadsheet to another (in the current Workbook). The range is e.g. all data in the cells of the row...
July 7th 03 06:56 PM
by Jesper Stocholm Go to last post
0 577
Linking To Excel Graphs by Steve[_27_]
I have a workbook with a worksheet that contains multiple graphs. I need to create OLE links to each graph and display the in object frames in a MS...
July 7th 03 03:12 PM
by Tushar Mehta[_6_] Go to last post
1 642
Prompt by rob p
Access 2000. I am creating a database query form Mas90 (sotamas90) table. I used the wizard and selected the fields I wanted. Works fine. I want to group by...
July 6th 03 11:37 PM
by merjet Go to last post
1 585
Count number of prints. by Eddy[_3_]
Supposed you want keep track of the number of printing of the sheet "Sheet2", put the following codes into the ThisWorkbook module:- Private Sub...
July 6th 03 09:00 AM
by Eddy[_3_] Go to last post
0 561
I need to determine a cell range based on a blank cell by Katrina
Debra Dalgleish > wrote in message >... > You could use a dynamic formula to define the range in Excel....
July 3rd 03 09:11 PM
by Debra Dalgleish[_2_] Go to last post
1 739
xlfCaller by Aaron Queenan
If I use Caller() in VBA code, I get a reference to the cell which includes the worksheet and workbook, but if I use xlfCaller, it only appears to give me the...
July 2nd 03 06:40 PM
by Rob Bovey Go to last post
1 846
Post New Thread


Display Options
Showing threads 173981 to 174000 of 174008
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:38 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.