fix code

Quick Summary: I have a macro that requires a column to contain numbers and letters in order to be run properly and I would like it to work either with just numbers, just letters, or both. I found a thread a while back that had a macro request and a solution that was very similar to what I was...

Hi guys, I am making a datasheet for a power substation and I created a number pad that has a command button on it called "Next" what I want this button to do is every time it is clicked it will automatically go to a specific cell and then be filled out. As of right now I do have code that works...

Hello! I am trying to come up with a code that does the following things: I have two sheets, sheet "RESUMO" and sheet "Gran.Solos NLT 10491". Each sheet has a cell named "Sample" next to which the sample number is written. In sheet resumo there is a column full of sample numbers, and I need for...

So I have come up with this really simple code Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = Me.Range("I") Then If Sheet("CAPA").Cells("G9").Value = "" Then Target.Hidden = True Else Target.Hidden = False End If End If End Sub And It is not working, can anyone help me...

This is the code I have been using to delete the names of rows when a button is clicked. It is no longer working, and I am not sure why. Any suggestions? I have tried it with and without my little warning message box. Please and thank you! 'This deletes ROW NAMES on THIS worksheet. 'This...

I'm having the hardest time trying to figure out how to run the macro on multiple sheets simultaneously. Therefore, the data should update for all 4 sheets, but that doesn't happen. Instead only the first worksheet gets update. I know the issue has to do with the first couple of lines. Here's...