Search results for query: *

Greetings, I have come across a strange occurrence that I can't source: With a certain workbook I have open, closing Excel completely using the upper-most and right close button (x) gives the following message: "A formula in this worksheet contains one or more invalid references. Verify that...

Hello I currently have an one-dimensional array (distinctCusts) filled with strings. I am printing the values of the array onto a worksheet by looping through a "for" loop as follows: With Range("X6") For iCust = 1 To nDistinctCusts .Offset(iCust, 0) = distinctCusts(iCust) Next End...

Hello, I am trying to change the value in a cell only if the worksheet is protected, but I can't seem to find the correct syntax. The code is as follows If [Worksheet g is not protected] Then g.Cells(1, 3).Value = 1 End If I don't want excel to attempt to write the value in the locked...

I am using the following code in a macro to simply write data to an array and then output the results to a worksheet. Sub test() Dim Arr(0 To 5) As Double, row As Integer Dim i As Double row = 1 For i = 0 To 5 Step 0.5 Arr(i) = i Next i For i = 0 To 5 Step 0.5 Cells(row, 1).Value = Arr(i)...

Greetings, I have a spreadsheet with a cells in a column (say column B) that use a VLOOKUP formula to return a value that depends on what the corresponding cell in column A says. Is there some way to say that IF(A#="",take user input,use VLOOKUP formula)? I have tried doing this using data...

Hi there, I have a macro that basically moves a bunch of cell ranges around, prints the worksheets, and moves the cells back to their original locations. A sample: Range("Q85:W107").Select Selection.Cut Destination:=Range("A225:G247") Range("Y85:AE107").Select Selection.Cut...

I have a workbook which has no macros associated with it, but every time I open it, the warning about macros and enabling/disabling them appears. Is there a way to fix this. Thanks.

My objective is to have two combo boxes, with the second box populating depending on what is selected in the first box. Currently this is performed by the following: 1. The first box populates from a list (A2:A17)and outputs the number of the selection to cell A20. 2. Cell B20 uses...

Can anyone tell me why this formula will not work in excel? Do I have too many if statements--I can't figure it out![mad] Every time I push ctrl+shift+enter it says the formula contains an error and then highlights INDIRECT (bold below). What does this mean? Thanks, Matt...

Hello again. I have a line graph which plots data from column B. I need to add a series to this chart that plots only the 0's from column B, because I need to show the zero points with a different colored line. How can I do this? Thank you!

Hello! I have 2 columns of data--column B contains data corresponding to a date and time recorded at 10-min intervals in column A. I am trying to create a simple line graph of the data in column B over a month's time period, thus plotting over 4000 points. My problem is, if I graph the...

Hi. In one cell a user enters 1-12 depending on the desired month. In another cell, the name of the month should appear. However, January is the only thing that appears. I know that this is because these numbers represent so many days after January 1, 1900. How do I get around this? Thank you!

Greetings, Here is my situation. I have two columns with data, column A has timestamps with the date and time at ten-minute intervals, and column B has the data corresponding to the timestamps. The data can run over any length of time. I am trying to create a line graph of this data...

Hello, I have a column of numbers, but each number has a comma at the end of it. I would like to be able to do calculations with these numbers, but they don't work with commas. Is there any way to format the column of data or run a filter or something to remove or ignore the commas?

Greetings, The following code fills in date and times from starttime to stoptime (entered into cells B7 and B8 respectively) in column A. It also enters a direction in column E (in degrees), if an offset direction (entered into cell B6), which is added or subtracted from data in column D, is...

Greetings, I have some data which contains time stamps with the format m/d/yy h:m0, data every ten minutes. In cells B7 and B8 the user enters start and stop times respectively. From this I can calculate the row which would contain the stop time, displayed in D8. I have also calculated the...

I have what looks like this: Time Date 230 11902 240 11902 250 11902 300 11902 310 11902 320 11902 330 11902 say in columns A and B. What I need is cell C2 to read "1/19/02 2:30." How would I write the function to combine cells A2 and B2?

I have collected curves for as many different brands of a single product on the market as possible, and I have each one on a separate excel worksheet named for the corresponding product (i.e. a workbook named Hoover with a different vaccuum on each sheet, a Kirby workbook, etc). My problem is...

I am using the INDIRECT function to reference a range for information. My formula looks like: =AVERAGE($B$57:INDIRECT($E$44)), where $E$44 contains something like $B$100. My problem is I need to use a formula like this on a different sheet referenced back to my original, something like...

Greeting, I have data in cells A57:F65536 and I need the cells in the row to turn yellow if the cell in column B corresponding to that row contains a zero. In other words, if B100=0, then cells A100:F100 would turn yellow, I can't figure out the code and I was wondering if someone could help...