cel.value

Hi I have the following code on a command button, the code runs on 2 other worksheets as well as this one - I need to protect the worksheets (formulas) but need the command button to still work, is that possible? As I have tried several different methods and can't get one to work! Thanks The 3...

I have a workbook that will run 27/7 on a pc and also another workbook I will use scheduler to open 2 times a day, save and close. The code I will run in the workbook I will open 2 times a day is below. Can this be edited to open in a new workbook and close so it does not disturb the other...

I'm using this code right now but would like to have an additional feature. Can this save and close unless the user hits a key or command button. That way when it opens I can be kept open if someone wants to view it longer. I will have this open, save and close once a day to keep it updated...

Good afternoon. I have a single Row A1:TT1 with data I have imported from an API output. The data looks similar to this and I import it using a comma delimiter [{"instructorEmail":"jby@xyz.com","instructorUserId":"123","timeZoneName":"(UTC+01:00) Brussels, Copenhagen, Madrid...

Hi, this is my current code. Sub test() Dim col, ro, col2 As Double Dim sCellVal As String col = 0 col2 = 0 ro = 0 Dim cel As Range sCellVal = Range("C9").Value If sCellVal Like "Night" Then For Each cel In Worksheets("Service").Range("C41:NR41") If cel.Value = Range("B9").Value Then...

Hi All I'm currently using some VBA to hide rows based on value in a cell and what I would like to do is apply that code to a range of worksheets in the workbook, how would I go about this. Lets say the worksheet names are called Month1, Month2, Month3 etc through to Month12. This is my code...

Hi, I have a code For Each cel In rng If IsEmpty(cel.Value) Or cel.Value = vbNullString Then cel.Value = "N/A" End If Next cel However, this code does not seem to work when I enter it in a different module. I can trying to amend this code so it...