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
Can we write VBA code to set all column/row's size back to default size? by Charles Williams
You can use the worksheet standaheight and standardwidth properties ActiveSheet.Rows.EntireRow.RowHeight =...
July 8th 03 03:56 PM
by Charles Williams Go to last post
0 374
dates in userforms by Ben Guenther
Thank you so much! I was starting to loose my mind! Your solotion works great. Thanks again, Ben *** Sent via Developersdex http://www.developersdex.com...
July 8th 03 03:44 PM
by Ben Guenther Go to last post
0 344
Check mark boxes in Excel 2002 by Dan E[_2_]
Nicole, If you have the control toolbox open make sure that you are out of design mode. The button looks like a triange, ruler and pencil (in excel 2000). If...
July 8th 03 03:41 PM
by Dan E[_2_] Go to last post
0 373
LoadPicture Pathname or no Pathname by Philipp Schramek
Dear all I used following code Image3.Picture = LoadPicture("TempVB.gif") in a UserForm-Object. It worked withoug the pathname, since the file was in the...
July 8th 03 03:30 PM
by Tom Ogilvy Go to last post
1 401
Mouse by Dan E[_2_]
Here's irony, Your Logitech mouse scrolls, but my Microsoft mouse doesn't Dan E "Paul B" > wrote in...
July 8th 03 03:29 PM
by Dan E[_2_] Go to last post
0 290
adding changing number of days by Aivars
Hello, Bank calculates loan repayment due dates like this: 1 181 day from drawdawn day 2 184 days from previous payment day 3 181 days from previous payment...
July 8th 03 03:26 PM
by Tom Ogilvy Go to last post
2 321
Cell contents changing colors by Barmaley
Just a little correction, it should be: =DATEDIF(A1,TODAY(),"m")>5 otherwise it calculates over 7 month, not 6 "Pieter Kuyck" >...
July 8th 03 03:24 PM
by Barmaley Go to last post
0 304
Add PivotItems to PivotTable / Enabling - Disabling PivotItems by Ole[_3_]
Hi there, is there any way to change the visibility - state of PivotItems AT ONCE ? With an "Offline OLAP - Cube" this is possible. I'would like to know, if...
July 8th 03 03:24 PM
by Tom Ogilvy Go to last post
1 477
Opening an AutoExecute Macro Workbook from an AutoExecute Macro Workbook by Tom Ogilvy
You can't close the calling program. Code can't just halt and disappear - at least it is not designed to behave this way. What you would have to do is put...
July 8th 03 03:21 PM
by Tom Ogilvy Go to last post
0 327
Associating one array with another by Michael J. Malinsky
Well that was easy, I guess that's why I don't get paid to do this for a living! Thanks, Tom Mike -- Michael J. Malinsky
July 8th 03 03:11 PM
by Michael J. Malinsky Go to last post
0 250
declare a two dimenssion array by Tom Ogilvy
Or you can just declare the whole array as variant and store what you want in each element. Bit more overhead, however. Or you could declare the whole array...
July 8th 03 03:06 PM
by Tom Ogilvy Go to last post
0 282
Ah, I think... by Don Guillett[_4_]
does this help Sub CLOSE_ALL() Application.ScreenUpdating = False Application.DisplayAlerts = False For Each w In Workbooks ...
July 8th 03 03:04 PM
by Don Guillett[_4_] Go to last post
0 378
Question: Cell formula or macro to write result of one cell to another cell by Frederik Romanov
Excel-97 (SR-2) This is a long term problem that I have with Excel. I mostly write worksheet applications that have plenty of user-configurable parameters up...
July 8th 03 03:03 PM
by Tom Ogilvy Go to last post
1 691
Before Send by Jan[_6_]
Richard, You can assign a macro to most of the menubar buttons. Do this by customising the menubar. Then you can choose to do the "Send To" from withing...
July 8th 03 03:01 PM
by Jan[_6_] Go to last post
0 377
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 393
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 335
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 399
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 407
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 542
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 606
Post New Thread


Display Options
Showing threads 173981 to 174000 of 174022
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 06:36 PM.


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