Forum Discussion

B_H33's avatar
B_H33
Copper Contributor
Nov 02, 2021

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...
Macros and VBA
B_H33's avatar
B_H33
Copper Contributor
Nov 02, 2021
Hi Jan,
I only want to auto sort column F.
Can you help me write a script?
JKPieterse's avatar
JKPieterse
Silver Contributor
Nov 03, 2021
B_H33 Have you tried recording a script yet?
  • B_H33's avatar
    B_H33
    Copper Contributor
    Nov 03, 2021
    Yes I did today. But when I run it it only sorts column F and doesn't extend to other columns...
    • JKPieterse's avatar
      JKPieterse
      Silver Contributor
      Nov 03, 2021
      Please paste your current script result here, I'll see what I can do.

Resources