topleftcell

Hello everyone, I am having an issue with ActiveX Checkboxes but I don't know what the problem is or how to fix it. So I have a sheet like this: [/URL][/IMG] And I have a code running to make everyone in column B have their own sheet. However, I only want that to happen if the checkbox in...

Hi. I have a table that will continually expand as new rows are added (thanks to a preceding macro). Each row has a range of cells with data and formula in them ($B17:$K17), but I I want to have a button (or double-click cell) in $L17 that calls a follow on macro. When I click that button I...

I have been using buttons to insert new rows above them. So the specific inserting action I perform is due to the location of the button. I need to use a similar method to insert a selection(or copy) from another place in the sheet(that I have hidden). I want to insert that selection of 3 rows...

I have tried to figure this out but for the life of me I can't. First, I will show the code: Sub ClearPic() Dim ws As Worksheet Dim sh As Shape Set ws = ActiveSheet For Each sh In ws.Shapes If sh.TopLeftCell.Address = "$G$2" Then sh.Delete Next sh End Sub This works great just running...