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
VB Format command fails by kirkm[_8_]
Hi, Anyone know what's wrong here? Cell(1,1) contains "00/11/1975" as text. Dim v as Date v = Format(.Cells(1, 1), "mmm yyyy") If v is dimmed as a...
May 1st 09 09:01 AM
by Harald Staff[_2_] Go to last post
9 293
Trying to create a formula in MSExcel 2007 (DATE based) by [email protected]
So I am trying to create a formula in excel that is based off of a start and end date. It's probably fairly simplistic, but I am missing sme...
May 1st 09 08:08 AM
by Jacob Skaria Go to last post
1 120
file names with full path by Eddy Stan
Hi Any help for a pull down list (validation) can the names of active workbooks be listed with a pull down list at b5 in the active sheet called "Form...
May 1st 09 07:19 AM
by Jacob Skaria Go to last post
1 120
Select method of Range class failed error message by Jacob Skaria
Oops. Row should be first .. Set insiteWS = Worksheets("Sheet1") Set rngInsitehdr = insiteWS.Range("A2", Cells(insitelastRow,...
May 1st 09 07:04 AM
by Jacob Skaria Go to last post
0 145
Select method of Range class failed error message by Jacob Skaria
Hope inSitLastColumn and insitelastrow are dimensioned as Long.. Set insiteWS = Worksheets("InSite Data") Set rngInsitehdr = insiteWS.Range("A2",...
May 1st 09 07:01 AM
by Jacob Skaria Go to last post
0 113
Workbook with macro by Big John[_3_]
Hi all. I have Excel 2003. I have several excel files in a folder. How determine if there are files with macro i.e. vba code and have a detailed list in a...
May 1st 09 05:18 AM
by Big John[_3_] Go to last post
2 133
Loop and running total by LuisE
I need to loop from row 50 to 1, step -1. Addin the values in Col A is equal as long as they are equal to the one above. How can i keep a running total that...
May 1st 09 03:53 AM
by Bernie Deitrick Go to last post
1 138
datediff by Mijosuva
Dear Expert I try to use DateDiff but it doesn't work, when I try to use this simple function excel say #NAME? This is what I have Function...
May 1st 09 02:36 AM
by Mijosuva Go to last post
5 155
Array, Match, ignore, List by Curious[_6_]
A column has many many rows and most of the rows are empty. Those with figures show a pattern like (100) (99) (98) (4) (3) (2) (1) 0
1 158
Code help by MAX
Will you please tell me what I have wrong with this code? In Workbook: Private Sub Workbook_BeforeClose(Cancel As Boolean) stopFlashing End Sub Private...
May 1st 09 01:32 AM
by MAX Go to last post
6 183
Ontime problem; variable not passed from Workbook_Open to StartTim by thomas
My ontime program is suppose to run the macro every 15 minutes of the clock starting from 9.00am to 12.30pm and then from 2.00pm to 4.45pm. In between the...
May 1st 09 01:08 AM
by thomas Go to last post
4 189
Runtime Error 381 - Invalid Property Array by [email protected]
Hello All, {Excel 2007, PC, novice} I have a userform which contains a ComboBox showing the bound column data. It supplies two Text boxes with data from...
5 1,450
delete all rows except by J.W. Aldridge
need to delete all rows except those containing "apples" and or "oranges" in column G. code below works, just need to add second criteria. assuming that "a"...
May 1st 09 12:44 AM
by JLGWhiz[_2_] Go to last post
5 191
Export unlocked cells to file by dan dungan
Hi, Using Excel 2000 and Windows XP, I'm attempting to export all the values in unlocked cells on the active sheet to a text file on my c: drive. Here's my...
May 1st 09 12:05 AM
by Dave Peterson Go to last post
4 154
Copy/Paste Template to New Workbook by Polo78 Lacoste
I have a template with two worksheets, sheet1 with the actual template which has about 20 vlookups and other formulas. Sheet2 contains the range for the...
(Multi-page thread 1 2)
April 30th 09 11:21 PM
by Polo78 Lacoste Go to last post
11 300
Problem with customized RichText Control by RB Smissaert
As there is a security problem with the regular RTF control, RICHTX32.ocx, somebody made for me a customized RTF control based on the regular RTF control. I...
April 30th 09 11:07 PM
by RB Smissaert Go to last post
1 159
looping on excel files in directory by christopher ward
Hi All If you can help my kindest thanks and sorry if I do not explain my issue very well - I am no longer a programmer being old and grey ( whats left ) I...
April 30th 09 10:42 PM
by Eddy Stan Go to last post
5 212
Creating an Excel Pivot Table using COM in C# producing 0x800A03EC by MattW[_2_]
I am attempting to create an excel pivot table programatically using the Excel 12.0 Library. The code I am using is below and I have marked the point where...
April 30th 09 10:30 PM
by MattW[_2_] Go to last post
0 430
Problem using group function with hidden rows by jday
I have a worksheet containing 10 sets of rows containing different versions of data. Within each of these 10 sets, there are "grouped" rows that can be...
April 30th 09 09:55 PM
by jday Go to last post
0 278
import from excel to access with macro? by J.W. Aldridge
Have existing access table. Imported data from the following source. C:\Documents and Settings\jw\Desktop\Sheet3 Need macro in access that will return to the...
April 30th 09 09:05 PM
by J.W. Aldridge Go to last post
2 139
Post New Thread


Display Options
Showing threads 20001 to 20020 of 174032
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 02:48 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.