 | Senior Member with 845 posts. | | Join Date: Sep 2007 Location: Moldova Experience: Intermediate |
11-Sep-2008, 02:15 PM
#16 | Why not just to add a new column in which to input the type (VHS, DVD, or any aother) and after that just use Auto filter (which will show only the type you need) and you can easily print it or any other thing!
It's more easier than using bold!
__________________ “I hear, I know. I see, I remember. I do, I understand.” (Confucius 551 BC – 479) | | Distinguished Member with 6,293 posts. | | Join Date: Oct 2004 Location: Southwest Iowa.... Experience: Currently stupid... |
11-Sep-2008, 05:05 PM
#17 | Probably that would have been the easiest before, AJ, but now that she has done the bolding, she is trying to save some work.
But really, the Name and range item I put in before is very simple.
You go to Insert, Name and in the Refers To box enter
=GET.CELL(20,OFFSET(INDIRECT("A2"),ROW()-2,0))
Name the function something simple (I used bold_cell) and then in a new column after A enter
=bold_cell
If a cell is bold, it will return TRUE, if not it will return FALSE. Then filter that column for the TRUE.
__________________ Iowa? I could have sworn this was heaven.
Well, I think I can answer this question most successfully in mime. My theme song... | Affero - rate me! | | Distinguished Member with 7,166 posts. | | Join Date: Jul 2005 Location: The void AKA edge of the Fens Experience: I bent my wookie :( |
11-Sep-2008, 05:16 PM
#18 | Quote: |
Originally Posted by slurpee ... now that she has done the bolding ... | Exactly. Plus there was the possibility it wasn't a "proper" list, which (turns out) it wasn't -- it was 4 columns of titles.
Fixed now with a standard For Each > If Cell.Font.Bold = True etc.  on the =GET.CELL BTW. I've cribbed a similar thing before for grabbing page breaks.
__________________ "Love All The People." Bill Hicks, 1961 - 1994 -- R.I.P. | | Former Administrator with 104,744 posts. | | Join Date: Jan 2001 Experience: Advanced |
11-Sep-2008, 05:45 PM
#19 |  I NEVER, even placed you with that MSN Messenger screen name
Wow.
Ok, I've recovered now.
Another big THANK YOU!
Problem solved! | | Distinguished Member with 7,166 posts. | | Join Date: Jul 2005 Location: The void AKA edge of the Fens Experience: I bent my wookie :( |
11-Sep-2008, 05:58 PM
#20 | Quote: |
Originally Posted by Candy ... Ok, I've recovered now ... | I ½-thought of a comeback involving "recovery position" but ... <cwlmst>! | | Former Administrator with 104,744 posts. | | Join Date: Jan 2001 Experience: Advanced |
12-Sep-2008, 12:11 PM
#21 | slurpee, thank you too!!!! | | Distinguished Member with 6,293 posts. | | Join Date: Oct 2004 Location: Southwest Iowa.... Experience: Currently stupid... |
13-Sep-2008, 05:33 AM
#22 | so, it sounds like our friend bomb has secrets? glad he fixed it for your Candy. | | Former Administrator with 104,744 posts. | | Join Date: Jan 2001 Experience: Advanced |
21-Sep-2008, 10:01 PM
#23 | I'm back
Would it be too much to ask to get the "unbolded" ones pulled out separately? | | Distinguished Member with 6,293 posts. | | Join Date: Oct 2004 Location: Southwest Iowa.... Experience: Currently stupid... |
22-Sep-2008, 12:14 AM
#24 | What would you have done with them? Copied to another sheet? Deleted? Sent to Mars? | | Distinguished Member with 7,166 posts. | | Join Date: Jul 2005 Location: The void AKA edge of the Fens Experience: I bent my wookie :( |
22-Sep-2008, 12:58 AM
#25 | "Too much" = doubtful. "Easier if I'd asked for both things at the same time" = likely.
I had the file when I worked on it, then ditched it straight after because ... that's what I do.
It was a sheet with 4 lists in 4 columns. So it would have been like:
For Each Cell in Selection
If Cell.Font.Bold = True Then
Cell.Copy Sheets("Sheet_I_Added").Range("A"&Rows.Count).End(xlup).Offset(1)
End If
Next Cell
, selecting each list in turn & running manually.
Except now it would be Font.Bold = False.
HTH
__________________ "Love All The People." Bill Hicks, 1961 - 1994 -- R.I.P. | | Former Administrator with 104,744 posts. | | Join Date: Jan 2001 Experience: Advanced |
22-Sep-2008, 11:20 AM
#26 | Ok, so what do I do with that? Open my main page where everything is bold and not bold, then what?
Create a macro? And if so, step by little baby step please. Remember I'm software challenged | | Distinguished Member with 7,166 posts. | | Join Date: Jul 2005 Location: The void AKA edge of the Fens Experience: I bent my wookie :( |
22-Sep-2008, 11:26 AM
#27 | IIRC there's no sensitive data -- attach it. | | Former Administrator with 104,744 posts. | | Join Date: Jan 2001 Experience: Advanced |
22-Sep-2008, 11:37 AM
#28 | Nothing sensitive, just my list of movies  Thanks a bunch !!!!
And I would have asked for it both ways from the beginning  except hubby asked for a list of only the DVDs yesterday  I should have anticipated that | | Distinguished Member with 7,166 posts. | | Join Date: Jul 2005 Location: The void AKA edge of the Fens Experience: I bent my wookie :( |
22-Sep-2008, 11:41 AM
#29 | 5 minutes.
ETA: attachment.
Last edited by bomb #21 : 22-Sep-2008 11:49 AM.
| | Former Administrator with 104,744 posts. | | Join Date: Jan 2001 Experience: Advanced |
22-Sep-2008, 11:46 AM
#30 | Thanks, you're a gem |  THIS THREAD HAS EXPIRED.
Are you having the same problem?
We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.
|
Smart Search
| Find your solution! | |
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | | |  WELCOME TO TECH SUPPORT GUY! Are you looking for the solution to your computer problem? Join our site today to ask your question -- for free! Our site is run completely by volunteers who want to help you solve your computer problems. See our Welcome Guide to get started.
| You Are Using: |
Advertisements do not imply our endorsement of that product or service.
All times are GMT -5. The time now is 03:39 PM.
Copyright © 1996 - 2009 TechGuy, Inc. All rights reserved.
Powered by vBulletin, Copyright © 2000 - 2009, Jelsoft Enterprises Ltd. | |
|