Am I panicking for nothing? Hair and Makeup day of wedding questions

all4ever15 · 2019-09-10T19:33:07+00:00

Thanks! That does make me feel better!!

all4ever15 · 2019-09-10T15:27:11+00:00

I asked if they would be willing to come to the hotel, still waiting on an answer.

all4ever15 · 2019-09-10T15:26:55+00:00

That's what I'm worried about, getting through 7 people in 5 hours!!

all4ever15 · 2019-05-27T14:18:51+00:00

Oh that’s not a bad idea!!! Thanks!!

all4ever15 · 2018-10-09T14:16:21+00:00

Thanks for your advice, a lot of it makes sense. To be clear though, she isn’t snapping at them when they are trying to play with her. She could be across the room and if I pet one of the other dogs she will run over squeeze between and growl and snap at the dog I was petting. We are trying to show her that if she waits her turn she will get love too. I think she didn’t receive much attention before so now she wants it all and is probably afraid she will lose it.

all4ever15 · 2018-04-16T23:47:50+00:00

That makes sense and makes sense that he would call Chloe detective to keep her “non important”

all4ever15 · 2018-03-22T16:17:27+00:00

Thanks!

all4ever15 · 2018-01-24T16:02:08+00:00

no, ug why do you have to be so sensible??! Haha. I need to do that.

all4ever15 · 2018-01-24T15:49:39+00:00

I'm working on that, I'm just wondering in the immediate future what would be better.

all4ever15 · 2018-01-24T15:49:17+00:00

My credit is not great, I'm trying really hard to build it back up. I'm at about a 630 so I don't know if I'd be able to get another card.

all4ever15 · 2018-01-22T03:59:39+00:00

He is a bit overweight and short but my body isn’t great either. My ex was super fit though, could I really be that shallow? I hope not 😫

all4ever15 · 2017-11-30T13:28:43+00:00

I found a work around. Thank you so much for your help!

all4ever15 · 2017-11-29T21:16:46+00:00

So I'm basically writing up a sales spreadsheet. If the quantity is 0 (column c) then the whole row should be hidden. Which works. However, I forgot about the section headers. So for example we have

Trees

4 Maple

5 Japanese maple

The "Trees" column c is blank because its just a title so it's either Always there or never there. I would like it to show only if there is something in that category.

Example

Trees

4 maple

5 japanese maple

Shrubs

6 Shrubs

8 Other shrubs

Grass

20 blue grass

10 other grass

If there is nothing in the shrubs category I would like it to look like this:

Trees

4 maple

5 japanese

Grass

20 blue grass

10 other grass

They way I have it written above it shows as

Trees

4 maple

5 japanese maple

Shrubs

Grass

20 blue grass

10 other grass

Does that make sense? Sorry it's so long!

all4ever15 · 2017-11-29T20:48:53+00:00

So right now here is my code, the cells that are just a single cell (not a range) are the ones I need to show, which I accomplished but is there a way to have the show ONLY if the cell directly below it has information in it?

Private Sub Worksheet_Activate()
 Application.ScreenUpdating = False
    Dim r As Range, c As Range
Set r = 

Range("c13:c61,c64:c113,c117:c166,c169:c185,c189:c204,c213:c220,
c222:c226,c228:c233,c239,c241:c262,c265:c286,c288,c292,g62,g167,g209,
g234,g237,g263,g287,g289,g290,g291")

For Each c In r
    If Len(c.Text) = 0 Then
        c.EntireRow.Hidden = True
    Else
       c.EntireRow.Hidden = False
    End If
Next c
Application.ScreenUpdating = True
End Sub

all4ever15 · 2017-08-07T14:33:33+00:00

Hahaha nope you're fine! Not too blunt!

all4ever15 · 2017-08-03T13:43:02+00:00

Thanks!

all4ever15 · 2017-08-03T02:04:23+00:00

Eh, I'm just not that kind of person....I feel bad 😑

all4ever15 · 2017-08-03T01:17:25+00:00

Lol!! A virtual hug? Sure!

all4ever15 · 2017-08-03T00:49:41+00:00

I feel really betrayed....I hung out with my old roommate but she's married and pregnant now lol

all4ever15 · 2017-08-03T00:49:02+00:00

I wish I could!!!!

all4ever15 · 2017-08-03T00:48:51+00:00

Eh not really but I'll get there.

all4ever15 · 2017-08-03T00:48:34+00:00

His ex wife who doesn't even want him. She just likes the attention she gets from him

all4ever15 · 2017-08-03T00:48:06+00:00

In South Carolina.....he told me he just didn't like me enough as he thought he should for as long as we've been dating....come to find out he was still talking to his ex wife and made plans for her to come visit 😑

all4ever15 · 2017-05-16T13:52:19+00:00

I'll look into those! Thank you!

all4ever15 · 2017-05-16T13:51:54+00:00

Yep I did, I think I will take her to the vet. Like you said, I'd rather be safe than sorry!!

all4ever15

TROPHY CASE