I am trying to export specific columns from a defined table to CSV. If I use the following only the first column is output:
With sh.ListObjects("MasterData")
Set rngToSave = Application.Union(.ListColumns("FATHER'S MOBILE").DataBodyRange, .ListColumns("CENTRE").DataBodyRange)
End...