A Microsoft Office (Excel, Word) forum. 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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : General Discussion Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
Columns WON'T highlight by deidrefw83
When I click on the column heading the column doesn't look highlighted. It's really annoying when I'm doing a find and cant see where it is due to it not...
March 24th, 2010 06:41 PM
by Bob I Go to last post
1 103
Replace ; with , in functions by Emece
When I use functions in Excel, arguments are differentiated by ; For example =sumif(range;criteria;sum_range) I want to use , instead of ; Where can I...
March 24th, 2010 06:23 PM
by Dave Peterson Go to last post
1 115
how to email worksheet, not as attachment by GTT
it function on office2003, upgraded to 2007 with lot of unhappy
March 24th, 2010 05:19 PM
by Billns Go to last post
2 107
Calculate the difference betwen two columns -two dates by Chi
Hi, I would like to calculate the hours between two columns: First Contact (G) and Appointment (H) with (m/d/yyyy) h:m AM/PM) format. First Contact (G) ...
March 24th, 2010 05:18 PM
by stumac Go to last post
3 157
Macro using a cell reference by Jason Falzon[_2_]
I have an aplication called DPlot that can take commands from inside excel using macros. I managed to interact already with it using the following: - Sub...
March 24th, 2010 05:16 PM
by Reg Go to last post
3 120
IF and VLOOKUP by ziak
Hello: Here's my array: A B C 1 Band Service Target 2 6 SAP 95% 3 7 SAP 96% 4 8 ...
March 24th, 2010 05:11 PM
by Eduardo Go to last post
2 87
Reference changes when I insert new columns in the source sheet by John Bare
I have absolute references set up to access data from a different sheet in the same workbook. When I insert new columns in the data source sheet, the...
March 24th, 2010 05:02 PM
by Reg Go to last post
3 136
How do I change the color of cells with a macro by Mike DFR
I was using conditional formatting, but this only gives three options, I need 5 I am looking for a simple piece of code which says If cell A1 is not zero...
March 24th, 2010 05:00 PM
by stumac Go to last post
3 125
UDF's by shane
I'm trying my hand in UDFs. In practice I created the following UDF in a module Function Area(Length As Double, Width As Double) Area = Length *...
March 24th, 2010 04:37 PM
by Jim Thomlinson Go to last post
4 102
macro using cell value by Jason Falzon
Hello, I have an application called DPlot that can take commands from excel through a macro. I managed to pass information like so: - Sub...
March 24th, 2010 04:21 PM
by Jason Falzon[_2_] Go to last post
4 145
Count a cell in month format by Mike Wheeler
Cell data: 15-Feb REG 22-Feb REG 8-Mar REG 15-Mar REG 15-Mar REG 29-Mar APIN 29-Mar REG 29-Mar REG 29-Mar REG
March 24th, 2010 03:56 PM
by Jacob Skaria Go to last post
5 100
Using an action button. by MichaelZ
How do I insert a button into a spreadsheet that will "clear" all values from cells that are intended for inputting data, but not clear other cells that are...
March 24th, 2010 03:55 PM
by MichaelZ Go to last post
4 117
If Question by Tango
Hi, I have a column with times in it 11:28:46 AM 11:29:21 AM 11:29:50 AM 11:44:03 AM 11:44:10 AM 11:44:25 AM
March 24th, 2010 03:35 PM
by petedacook Go to last post
2 99
Help in macro coding by Sasikiran
Dear, I am working on a macro which trims the raw data into a desired one. i would require your help in adding the macro code to delete the entire row if it...
March 24th, 2010 03:34 PM
by Sasikiran Go to last post
3 121
Change cell background color based on content that results from li by joemc911
This could be very simple, but I will lay the groundwork first. I have a schedule spreadsheet that I import data to from a web based program. There are...
March 24th, 2010 03:16 PM
by John Go to last post
4 166
pasting values from pivot table still linked by ChrisC[_2_]
I have a fairly big table that provides values for a pivot table. I would like to view the data from the pivot table and copy and paste this information to...
March 24th, 2010 02:21 PM
by ChrisC[_2_] Go to last post
0 86
Worksheet Column Widths Different For Different Users by Falcon Feet[_2_]
There are 2 of us that use the same Excel Workbook. We are all using Excel 2003. When I check the widths of the columns in the Worksheet, they are...
March 24th, 2010 02:05 PM
by Falcon Feet[_2_] Go to last post
2 144
text value by AllyH
I need to rank a column containing concatonated names and addresses. Ranking only handles numeric values, is there any way to give text a numeric value?
March 24th, 2010 01:54 PM
by Mike H Go to last post
1 121
Having Problems Excel 2003 by BJ&theBear
I have been trying to rectify the anomalies in the data in a spreadsheet that has become a mishmash of different Project and Task codes in order to provide a...
March 24th, 2010 01:30 PM
by BJ&theBear Go to last post
3 125
Excel 'Back' Button by Jen
Hi All, I've got a webpage with a drop down menu which provides links to various Excel And Word documents. It works extremely well with Word but when you...
March 24th, 2010 01:16 PM
by Jen Go to last post
1 96
Post New Thread


Display Options
Showing threads 3321 to 3340 of 139764
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 Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 08:50 AM.


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