I have written the VBA function code below (it is in a module attached to the desired WorkBook) to work with a spreadsheet that is intended to work on a column...

I have the number 7 in a cell. In another cell I want to reference cell e7 (i.e. =e7). However, I want the number 7 in that reference to point to the cell...

I'm having an issue with calculating the work days between two dates. Is there a simple function that will accomplish this?? thanks for any...

I have used this newsgroup several times and always get my answer. Im just wondering who you people are that answer these questions? And thank you to you all...

I am simply trying to enter data as minutes (i.e. 40, 30, 45, etc.), add those minutes (in this case, to get 115 minutes), but have the display calculated in...

I am simply trying to enter data as minutes (i.e. 40, 30, 45, etc.), add those minutes (in this case, to get 115 minutes), but have the display calculated in...

I am simply trying to enter data as minutes (i.e. 40, 30, 45, etc.), add those minutes (in this case, to get 115 minutes), but have the display calculated in...

I am simply trying to enter data as minutes (i.e. 40, 30, 45, etc.), add those minutes (in this case, to get 115 minutes), but have the display calculated in...

Hi, I have about 400 cells that contain the date and time in this format 05/04/04 11:34 CDT How can I get just the date from these cells so that I can use...

I have this formula here which works as...

Hi, I want to use a Dynamic Range Name. From visiting Chip Pearsons site (excellant site!) I have the...

I have used this newsgroup several times and always get my answer. Im just wondering who you people are that answer these questions? And thank you to you all...

Is there a way to sum data for cells that are visible, that is not hidden? An example is below. With Columns C through G visible Col B Col C Col D Col E Col...

I have a macro that automatically saves a purchase order file with the name of the sales rep, but I want it to also include a value they enter in a particular...

I tried the below formula and it doesn't work properly. It's a macro. What I would like to do is print certain worksheets within a workbook on...

Hello all, can someone pls tell me how to protect one single cell in a worksheet..... thank u Lara

I have a cell (B5) that is referenced to another cell (A1). It simply copies whatever is inputted into A1 into B5. How do I make it so if there is nothing...

Hi, I have a sumproduct formula which I need to include an "indirect" function. How does it work? e.g. when I...

I need help with a function I don't quite understand. I have a column of numbers that are coded by initials in the next column. Example: Column A has 30...

I am using the topsheet of my workbook to reflect the information on all subsequent worksheets - each worksheet is represented by a row. I have a ton of...