Search results for query: *

That did it, PH! See, i knew it was something simple :) Thanks for your help! --Meg :)

PH -- so how do I tell it to only search my range selection? I think I'm just having a problem with the syntax. I also tried inserting Skips code instead, changing .Cells(lNextRow, 1).value = MyColAValue to .Cells(lNextRow, 1).select and then following with my paste.. I get an error on...

So my Range("A3:X500") is in the wrong place .. its selecting that range, and then looking outside of it for blanks.. oh yeh, and I didn't mean to have it say X476 in my code and X500 in my explanation. The rows don't matter, they can go to infinity.. I just don't want it to consider...

This is an excerpt of what I had -- 'copy Mn data Sheets("Concentration Calculator").Select Range("C9:C12").Select Selection.Copy 'find next blank cell in range on output sheet Sheets("Operating scenarios").Select...

Hey Guys -- I'm new to VB so I need help with a really simple task -- Its so silly I'm embarassed to ask! I have an input sheet where operators enter daily data. I want the output data to be put on a different sheet. The output sheet takes values (and not formats) from specific cells...

geoff : I've already tried that also (clearing the contents of the cells).. I have read the whole thread (a few times) and I am really frustrated! I've tried dynamic ranges, the NA function, clearing the contents of the cells, changing chart options, etc... <sigh> Thanks for the suggestion...

Sorry, I forgot to mention that I had already tried the NA() or #N/A .. it didn't fix the problem. They still show up on the chart. When I scroll over the graphed nulls, it says &quot;value: #N/A&quot; but is still graphed as a zero The null values aren't charted on a different line graph...

I'm posting on this thread because I think I have a similar question.. kind of.. I have a combination chart in Excel .. The base of the chart is a stacked bar that shows forecasted monthly figures for every month, Jan thru Dec. Combined on the same axes is a stacked line chart showing actual...

Yeh, sorry, that was a typo :) i meant to type 10/20/2003 12:12 (but not 10/20/2003 12:00) Anyways, Loomah, your code worked perfect! Thanks for the help !

I am looking to write an excel macro to delete rows in a sheet based on the &quot;minute&quot; value of the data. I have a sheet with a column that reads sort of like this : 10/20/2003 12:00 10/20/2003 12:12 10/20/2003 12:15 10/20/2003 13:00 10/20/2003 13:15 ... I'd like to delete the entire...