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
Conditional formatting of a Row by OssieMac
Can you post a sample range of cells that is to turn Red plus the cell address which will be zero when the range turns red etc. Need to know what the...
May 1st 09 11:39 AM
by OssieMac Go to last post
0 93
Comment Box to include a range of cells by N1KO
Hi, I need to make put a comment box on a cell but the actual comment comes from a range of cells on a different sheet. The range will always be ("B74:J80")...
May 1st 09 11:39 AM
by N1KO Go to last post
8 134
adding/appending comment by code by Jock
Hi, The following code should: 1) add a comment with text & date when a date is entered in a cell in 'I' 2) append the above comment with new text and date...
May 1st 09 11:33 AM
by Peter T Go to last post
3 192
VBA compatible code - PC to Mac by c1802362[_2_]
Does anyone know if there is a comparable VBA function on the Mac to Application.FileSearch.FoundFiles.Count on the PC? I'm running excel 2004 for Mac...
May 1st 09 11:19 AM
by joel Go to last post
1 151
Macros will not work when sheet e-mailed by joel
You should specify the worksheet and workbook to make sure it works. If this code is part of worksheet change you don't need the sheet name. with...
May 1st 09 11:09 AM
by joel Go to last post
0 122
Read Only by ekreider
I have an Excel program running on several (3) different computers and they access data from another computer called svr. I add and remove data from svr....
May 1st 09 11:03 AM
by ekreider Go to last post
0 109
formülü yaptıktan sonra nasıl gizlerim? by cuneyt
bir kişiye yollamak üzere formullü bir dosya oluşturacağım fakat bu dosyada formul olduğu anlaşılmasın istiyorum. mümkünmü bu acaba
May 1st 09 09:40 AM
by Hennie Neuhoff Go to last post
1 176
SpaceChart - can't see the chart by tuli
I have this macro in VBA excel. I can see the traces. Please advise. I am using ChartSpace from Microsoft Office 11. Xp pro. Thanks Tuli Dim oChart,...
May 1st 09 09:19 AM
by Peter T Go to last post
1 181
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 308
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 131
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 127
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 148
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 119
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 138
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 146
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 166
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 162
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 200
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 202
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,472
Post New Thread


Display Options
Showing threads 20001 to 20020 of 174039
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:09 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.