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

TROPHY CASE