Search:

Wow, unexpected news for sure! thanks for all of your help here over the years, Hans. Your dedication (85k posts) was incredible and I always wondered how long you could last. The funny part? ...

Hi WOPRs!

I have a linksys WRT54Gv8 router and a Zonenet ZEW2500P wireless adapter connected to my desktop via USB2.0. My problem is that every hour or so, my connection just drops with no...

You can highlight all cell you want to affect and then use the formula for the entire range.


I've attached a sample workbook.
You are correct! Thanks...

With the columns referenced absolutely, you can extend the formatting as far across the row as you want.


I entered the formula in C1 and then copied it to the right and then down in the attached...

The formula to use for the row would be:
=or($a1="x",$b1="y")

i know the or() formula.. but i thought that can only be used to highlight a single cell, no?

Here's the scenario: you have 2 columns, A and B. Column A sometimes has cells with the value "X" and Column B sometimes has cells with the value "Y". You want to highlight the entire row if...

You could still use a macro and look like an Excel expert:

Sub Macro1()
With Selection.EntireColumn
.Replace What:="_", Replacement:=" "
.Replace What:=" ", Replacement:=" " ' What...

http://windowssecrets.com/forums/images/smilies/laugh.gif how anti climatic. so much for the 30 lines of non-working code I wrote http://windowssecrets.com/forums/images/smilies/smile.gif

Thanks...

here's 25 rows of data from my spreadsheet. I'm currently working on trying to write a for next inside another for next loop to do what i'm looking to do but I haven't gotten too far quite yet ...

I am currently using a series of cells to break down a wall of text that is received from a machine on our manufacturing floor. It gives us a block of data because it doesn't know how to separate it...

Even if the toolings are different, I'd still prefer to use a single table.

I'd create a series of tables that list the options, then use cascading combo boxes - see Basing one combo box on...

I'm trying to decide on how I want a tooling database that I'm creating to work. I've got a table for each type of tooling, since they are all different, and I want to be able to find any specific...

Whoops, I was writing stuff down for a database at the same time... but my question is for Excel 2007. Sorry about that!

How do you turn off row highlighting? It shows up in print preview and it's very obnoxious! Is there any way to get rid of it?

Thanks Hans! Glad to see you're still a posting-powerhouse here http://windowssecrets.com/forums/images/smilies/smile.gif

what does the join table do exactly?

I'm making a tooling database using Access 2007.

I first came up with how I will identify the ridiculous myriad of tooling we have here in a unique manner, which is very very difficult for me...

OK, I'm going to approach this by designing it in Access and then probably convert the back-end to SQL after it's set up. Finally, I may eventually re-do it as a web-based interface "in my spare...

alrighty, thanks for the replies guys... I'll see if I can convince him to do an access front end. But I know the argument will be: "what if I want to check the database from someone else's computer...

I just checked my join date of these forums in my profile - July of 2004. I first came to this site for Access help, and you guys were great http://windowssecrets.com/forums/images/smilies/smile.gif...

I will let you work out the details and the simplification. It can be done without calculus.

If we are given the 3 dimensions: D, the diameter of the circle, x the base of the triangle, and y the...

OK, so this isn't really a puzzle, but I'm sitting here at work stumped on it http://windowssecrets.com/forums/images/smilies/laugh.gif And I knew if anyone could answer it, the guys @ Woody's could...

ah, that was easy... just not so obvious in '07. Thanks!

I have a frozen pane and I'd like to have the top pane printed on each page. Is this possible? Or do I need to copy and paste it to each page break?

wow, that's a lame bug. Thanks for the link Hans, I can't believe MS left an issue like this in Excel... I mean, when would you want to copy hidden filtered data?! (rhetorical)