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
Help with autofilter and filtering a specific column by Drew[_11_]
in a macro that filters a specific column i have the following code... ActiveSheet.Range("A7:CQ199").AutoFilter Field:=31, Criteria1:="=3", _ ...
December 30th 09 10:11 PM
by OssieMac Go to last post
1 120
Detect "Save" menu event by Robert Crandal
How can I handle when the "Save" menu option is selected by a user?? I basically want to run some code either before or after a workbook save occurs. Does...
December 30th 09 09:46 PM
by Harald Staff[_2_] Go to last post
1 131
Automatic Refresh Date and Time by jaeson
Good Day, Can you help me into my problem using Excel 2000, I just want is when I'd Put =Now() in cell A1 it will aumatic running without pressing F9...
December 30th 09 09:41 PM
by Dave Peterson Go to last post
1 140
Better Understanding by Marsh
I am in the process of beginning to teach myself VBA for Excel 2007. The primer I am using starts with recording macros, editing recorded macros, and...
December 30th 09 09:35 PM
by Harald Staff[_2_] Go to last post
4 242
xl2007 - Slow Macros Involving Graphics by Greg Wilson
BACKGROUND: I developed an interactive Excel-based program for the engineering and construction industries using xl2003. It is essentially a picture...
December 30th 09 09:17 PM
by Greg Wilson Go to last post
3 190
Download a .csv file from a website by talkintotim
I was wondering if anyone knew how to code this with vba. I have a list of stocks in a spreadsheet, and want to download the .csv file from Yahoo historical...
December 30th 09 07:46 PM
by talkintotim Go to last post
0 148
Set focus to textbox after spin-button control is pressed?? by Homey
I try this an have same problem. it seem that where focus is at click control where focus go. if focus on spinner then focis go to textbox. but if focus on...
December 30th 09 07:39 PM
by Robert Crandal Go to last post
1 272
Worksheet function by Atif
Hi all, i am using following code to copy values from Source Workbook to Target Workbook, its working fine. vSourceWS.Range("A1").Copy...
December 30th 09 07:24 PM
by Rick Rothstein Go to last post
6 204
list worksheets in a workbook. by mepetey
I have a workbook that has upwards of 50 worksheets. Is there a simple way of generating a list of those worksheets names? I don't fancy having to do it...
December 30th 09 07:17 PM
by Chet Newman Go to last post
7 170
Losing Quotes by mcescher
Hi All, I often have a need to create a list of quote encased, comma separated values and generally they are in or can be created in Excel. So, I created a...
December 30th 09 06:45 PM
by mcescher Go to last post
2 167
ExecuteExcel4Macro by JP Ronse
Hi All, Using Excel 2003. Code: Option Explicit Const ALT_PLANNING_PATH As String = "D:\Data\Watch\"
December 30th 09 06:31 PM
by JP Ronse Go to last post
0 170
instr problem with formula by Shell
I am trying to use the following If InStr(1, "C:\", Range(strC & r).Formula) > 0 Then Print #1, r & strC & " " & " " & Range(strC & r).Formula End...
December 30th 09 06:13 PM
by Shell Go to last post
3 189
Statusbar has disappeared - Excel 2003 by Rich
There is no Statusbar (status bar) option in View/Toolbars either. If I do Full Screen or Not Full Screen -- there is no status bar. What can I do to...
December 30th 09 06:13 PM
by Rich Go to last post
5 326
Put parentheses around figures by andreashermle
Dear Experts: I would like to format selected figures with a specific syntax so that after running the macro parentheses are put around the...
December 30th 09 05:49 PM
by andreashermle Go to last post
7 494
set unicode in macro by GadyC
I wrote a macro -> xla. it returns manipulated and translated strings. after passing to win7 i get the output in wrong language code, probably unicode...
December 30th 09 05:35 PM
by Gary''s Student Go to last post
2 149
Excel 2003 vsto 2005 vb.net - ThisAddIn_Startup problem by RichardB
Hello, I have an add-in that works well and executes the me.startup event perfectly when Excel is started manually. If Excel is started by double clicking...
December 30th 09 05:20 PM
by joel[_440_] Go to last post
1 343
VBA for comparing data within a range for Excel 2003 by marcus[_3_]
Hi You don't need vba to solve this one. A formula will work just as well. Put this in the appropriate cell and drag it...
December 30th 09 04:49 PM
by jmberner Go to last post
1 157
Problems with Workbook Before Save Event by Ryan H
Thanks for the replay Dave. I did think about doing your suggestion before I read your post, but I decided not too. This is the code that I had to...
December 30th 09 04:36 PM
by Ryan H Go to last post
2 182
Referencing a Forms Button in a Worksheet by Ryan H
Thanks for the reply Dave. I realize "-" are not allowed, but it did NOT throw an error when I assigned a name to the forms button on the worksheet, weird...
December 30th 09 04:00 PM
by Dave Peterson Go to last post
3 185
How can I print a frame corresponding to page margins? by Paolo Moia
How can I print a frame corresponding to page margins?
December 30th 09 03:32 PM
by Paolo Moia Go to last post
0 140
Post New Thread


Display Options
Showing threads 10001 to 10020 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.