Forum Discussion
Help to convert VBA to Excel Online script
Hi, I need help converting a VBA to a Script for Excel Online. Can anyone help me with this?? VBA code is: Private Sub Worksheet_Change(ByVal Target As Range) On Error Resume Next ActiveSheet.Unp...
Hi B_H33
Office Script does not support event code like your Worksheet_Change event, you can only start scripts manually. Have you tried to record the steps using the script recorder?
Office Script does not support event code like your Worksheet_Change event, you can only start scripts manually. Have you tried to record the steps using the script recorder?
Hi Jan,
I only want to auto sort column F.
Can you help me write a script?
I only want to auto sort column F.
Can you help me write a script?
- B_H33 Have you tried recording a script yet?
- Yes I did today. But when I run it it only sorts column F and doesn't extend to other columns...
- Please paste your current script result here, I'll see what I can do.