# Search:

Type: Posts; User: officespacer; Keyword(s):

Page 1 of 20 1

1. ## Thread: A Tribute To Hans

by officespacer
Replies
103
Views
9,983

### Wow, unexpected news for sure! thanks for all of...

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? ...
2. ## Thread: Connection randomly drops, often

by officespacer
Replies
2
Views
468

### Hi WOPRs! I have a linksys WRT54Gv8 router...

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...
3. ## Thread: Conditional Formatting

by officespacer
Replies
6
Views
448

### You can highlight all cell you want to affect and...

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...
4. ## Thread: Conditional Formatting

by officespacer
Replies
6
Views
448

### With the columns referenced absolutely, you can...

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...
5. ## Thread: Conditional Formatting

by officespacer
Replies
6
Views
448

### The formula to use for the row would be:...

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?
6. ## Thread: Conditional Formatting

by officespacer
Replies
6
Views
448

### Here's the scenario: you have 2 columns, A and...

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...
7. ## Thread: Breaking down a line of text into individual components

by officespacer
Replies
6
Views
354

### You could still use a macro and look like an...

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

Sub Macro1()
With Selection.EntireColumn
.Replace What:="_", Replacement:=" "
.Replace What:=" ", Replacement:=" " ' What...
8. ## Thread: Breaking down a line of text into individual components

by officespacer
Replies
6
Views
354

### http://windowssecrets.com/forums/images/smilies/la...

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...
9. ## Thread: Breaking down a line of text into individual components

by officespacer
Replies
6
Views
354

### here's 25 rows of data from my spreadsheet. I'm...

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 ...
10. ## Thread: Breaking down a line of text into individual components

by officespacer
Replies
6
Views
354

### I am currently using a series of cells to break...

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...
11. ## Thread: General database setup questions

by officespacer
Replies
3
Views
326

### Even if the toolings are different, I'd still...

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...
12. ## Thread: General database setup questions

by officespacer
Replies
3
Views
326

### I'm trying to decide on how I want a tooling...

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...
13. ## Thread: Row Highlighting

by officespacer
Replies
3
Views
258

### Whoops, I was writing stuff down for a database...

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

by officespacer
Replies
3
Views
258

### How do you turn off row highlighting? It shows...

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?
15. ## Thread: Table Design

by officespacer
Replies
4
Views
378

### Thanks Hans! Glad to see you're still a...

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

by officespacer
Replies
4
Views
378

### what does the join table do exactly?

what does the join table do exactly?
17. ## Thread: Table Design

by officespacer
Replies
4
Views
378

### I'm making a tooling database using Access 2007....

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...
18. ## Thread: To use or not to use Access, that is my boss' question

by officespacer
Replies
7
Views
478

### OK, I'm going to approach this by designing it in...

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...
19. ## Thread: To use or not to use Access, that is my boss' question

by officespacer
Replies
7
Views
478

### alrighty, thanks for the replies guys... I'll see...

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...
20. ## Thread: To use or not to use Access, that is my boss' question

by officespacer
Replies
7
Views
478

### I just checked my join date of these forums in my...

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...
21. ## Thread: Volumes

by officespacer
Replies
3
Views
981

### I will let you work out the details and the...

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...
22. ## Thread: Volumes

by officespacer
Replies
3
Views
981

### OK, so this isn't really a puzzle, but I'm...

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...
23. ## Thread: Printing Freeze Pane headers - every page (2k7)

by officespacer
Replies
2
Views
834

### Re: Printing Freeze Pane headers - every page (2k7)

ah, that was easy... just not so obvious in '07. Thanks!
24. ## Thread: Printing Freeze Pane headers - every page (2k7)

by officespacer
Replies
2
Views
834

### Printing Freeze Pane headers - every page (2k7)

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?
25. ## Thread: Copy/Paste auto filtered range (2k7)

by officespacer
Replies
3
Views
416

### Re: Copy/Paste auto filtered range (2k7)

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)
Results 1 to 25 of 500
Page 1 of 20 1