General Discussion - Page 50 - OfficeFrustration

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.

		Home » OfficeFrustration forum » Microsoft Excel
General Discussion

Home

Page 50 of 6989

Threads in Forum : General Discussion

Forum Tools

Search this Forum

Thread / Thread Starter	Last Post	Replies	Views
Accenting letters in Excel by burric How do I accent the letter "e" with ` or ' in Excel? ( 1 2)	September 17th, 2009 03:58 AM by Fred Smith[_4_]	14	192
Changing Cell Link on Spin Button Form Control by Adam Ronalds I am copying a spin button several times (over 100 spin buttons in this input spreadsheet) and rather than having to go into the "format control" screen 100+... ( 1 2)	August 27th, 2009 05:52 PM by Dave Peterson	14	327
Adding Rows or Columns disorders my micro by Damian I have a group of cells that I copy certain information from and paste it to another cell for user to see. When the user adds rows or columns this macro... ( 1 2)	August 31st, 2009 07:25 PM by Damian	14	148
VBA errors in 2007 (works fine in 2003) by Horatio J. Bilge, Jr.[_2_] I have a workbook which uses Chip Pearson's sheet visibility method of ensuring that users enable macros (complete code at... ( 1 2)	September 6th, 2009 12:46 PM by Dave Peterson	14	548
setting up spreadsheet by Michelle using excel for sales contact log. i have row for each contact. I have several columns for each contact (name, co, address, phone ... date of contact, type... ( 1 2)	September 2nd, 2009 12:48 AM by Michelle	14	167
Macro working bar by Alberto Ast[_2_] I have a long macro runing under Application.ScreenUpdating = False but I would like to have a bar showing in prograss or some action so user will know... ( 1 2)	September 12th, 2009 03:12 PM by Gord Dibben	14	170
Count Between dates by juancarlos How can I count between two dates when format for the dates is DD-MM-YY I need to know how many days are between 21/04/09 and 28/04/09 The solution should be... ( 1 2)	September 26th, 2009 08:14 AM by David Biddulph	14	182
REPSOT?? Sub Worksheet_Change(ByVal Target As Range) by Ed Davis[_2_] I have 4 rages of cells that if any cell in these ranges changes I would like to change the Background and Foreground colors. However I only want to change... ( 1 2)	October 13th, 2009 03:20 PM by Dave Peterson	14	177
Formual to have Max $ amount by Carrie Good Afternoon, Currently I have this formula: =SUM(B6:G6)*(0.173) But I don't want the caluculation to exceed $711.03 Help ( 1 2)	October 26th, 2009 11:01 PM by Gord Dibben	14	200
leap year problem. by 2vao hello, I have this formula : =IF(OR(MOD(B1,400)=0,AND(MOD(B1,4)=0,MOD(B1,100)0)),"L","NL" (to show L if the date falls in a leap year). It works for 2008... ( 1 2)	July 24th, 2009 03:04 PM by 2vao	14	159
Pay day by nbslarson Our working period is divided into 2 sections a month: 1st thru 15th and 16th thru last. We are paid on the 6th of the month and the 21st of the month OR... ( 1 2)	July 24th, 2009 08:20 PM by Ron Rosenfeld	14	152
Is it possible to create a dropdown list with pictures/icons ? by Tom Vandewiele Hi, i am a project manager trying to create a progress report in MS Excel based on weather icons, these are small GIF's of sunny or cloudy weather. I would... ( 1 2)	August 27th, 2009 05:11 AM by Sean English	14	210
Help with calculations in Excel by Joel Welcome one and all to the most annoying Excel problem I have come across. My problem is as follows, I have set up an Excel spreadsheet to help me pay my... ( 1 2)	December 14th, 2009 01:57 AM by Fred Smith[_4_]	14	104
fill a series keeping the last number constant by cyndi Hi I am using Excel 2003, Hereâ€™s the problem, I need to fill a series keeping the last number constant: For... ( 1 2)	August 12th, 2009 06:53 PM by Demccaff	14	258
Format cell to Number by David R. S. I have formatted a excel 2007 cell as a number. I enter a 16 number credit card. The last 4 numbers a 6839 The cell automaticall changes the last 4 ... ( 1 2)	August 17th, 2009 04:03 PM by Ron Rosenfeld	14	246
sumif? array enter? by Jack Sons Hi all, I want to sum in column F those cells for which in their row one or more cells in the range AK:AO is not empty. I tried but did not succeed. Possibly... ( 1 2)	July 13th, 2009 05:34 PM by T. Valko	14	146
SUMIFS using an "Or" condition? by CG I am trying to write a SUMIFs formula using two sets of criteria from different columns, but I need it to be an "either/or" formula. Is there a way to do... ( 1 2)	July 13th, 2009 08:52 PM by Herbert Seidenberg	14	158
Vlookup off multiple columns by James Hello there I am trying to do a vlookup off multiple columns. For example below if I am trying to find the result of "22" for a value "ZZ" in columns A to C... ( 1 2)	July 22nd, 2009 02:31 PM by James	14	131
Storing formula in cell by Cinco I want to save the following formula in a cell: =Sumif(Indirect("S" &Q5+1 &":S" &R5),"" &V2,Indirect("R" &Q5+1 &":R" &R5))" I've tried using double "s at... ( 1 2)	July 26th, 2009 10:34 PM by Rick Rothstein[_2_]	14	161
Calculate the Circumference of an ellipse by M Is there a formula to Calculate the Circumference of an ellipse in excel? ( 1 2)	November 28th, 2009 04:45 PM by Dana DeLouis	14	255

Page 50 of 6989

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	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 Off HTML code is Off

Forum Jump

All times are GMT +1. The time now is 03:45 AM.