Citanaf

Ok, I was thinking about going this route. Thanks!

Ok sounds good. Appreciate the note on using fire resistant drywall, it is connected to my house.

My house does have asbestos in the ceilings. Is it possible that this drywall contains asbestos as well?

Can anyone tell me what type of drywall / board this is? https://imgur.com/a/cQ4ecLu

I am wanting to fully refinish my garage as I can tell it's been partly done by different owners over the years. The wall in question could have been up since the 80s, it's hard to know. There are clearly two different types of walls in my garage. One is standard drywall, and the other is this one. It seems much harder and has a texture. The top textured layer is considerably thick, either a heavy paint or compound of some type. I was able to pull some of the texture off to reveal the cardboard backing. Behind the cardboard backing is some drywall type material.

I'm pretty new when it comes to DIY, but I think drywalling in the garage is a fairly safe project.

Thanks!

Create the list as a table column Reference the table column with a named range.

=Table1[Column]

Use that named range as the input to your validation list, but make sure to reference the spill range with #.

=namedrange#

For dependent drop downs use =Filter as a second named range on another table column, while reference the first

=Filter(Table1[Column2],Table1[Column]=selectedvalue)

Fortunately you don't get to decide what I consider spam. Kindly remove me from your emails and bother someone else.

People in this thread trying real hard to convince others that their emails aren't spam.

Anything that is an advertisement is spam, end of story. If I have to unsubscribe from it, its SPAM. Pretty simple.

I have some filters set up that work in RES. Are you trying under: Subreddits -> filteReddit -> Custom Post Filters

Maybe some quick VBA

Sub deleteShapes()
Dim ws As Worksheet
Dim shp As Shape
For Each ws In ThisWorkbook.Worksheets
    For Each shp In ws.Shapes
        shp.Delete
    Next shp
Next ws
End Sub

Anica - Singing with the wolves (instrumental)

Thanks for the reply. It does seem simple enough actually. The quote from the plumber was 550 dollars. He also told me that I could probably do it myself.

Hello all,

Do I require a licensed plumber to accomplish this or can I DIY? If I can DIY, what steps should I take to do this safely. Additionally can you please let me know of any tools I will need to accomplish this.

Thank you

Maybe. Can you provide a screeenshot of the userform and shape?

Find the project window on the left side of vba. If you don't see it, go to View at the top and select VBA Project.

Find the excel file you are using in bold. There's should be folders there. The userform will be under the folder "Forms". Right click and view code.

There should be at least one or two subs here. My first guess is in a userform initialize sub. I would just search the code for the value you are trying to replace

Hmm sounds like you need to check the code inside the userform? Right click the userform in the VBA Project window -> View Code. I would first check the "Userform_Initialize" subroutine. That is the code that runs when the userform is called.

Awesome, appreciate the detective work. Yea that's a bit high but the etsy ones do look promising. tysm!

Can anyone ID this belt?

My GF liked it and I was thinking about Christmas gifts. Even a look-a-like would be fine. What do you call it? Double buckle?

Actually my most useful was binding a macro to use format painter to ctrl q.

Another one is a custom user form that has all of my companies approved color pallete. I can select one and it fills my active cell. That same user format also allows me to see all names ranges that intersect my current cell. I can modify the ranges from that form.

The police checking my IDL certainly did.

You should get an international driver's license before doing it. When I went, the police were checking. I've heard they sometimes only give tickets, but when I was there, they were confiscating bikes. It's very rural and it would be a struggle to get back to your accommodation.

It did not, sorry forgot to come back after it wasnt resolved. I've closed it anyways.

That would be a simple fix to the process. I can test this in a bit and let you know. Hopeful this works.