Skip to content

Instantly share code, notes, and snippets.

Avatar

Alasdair Walmsley AlasdairWalmsley

  • Brighton & Hove City Council
  • Brighton, UK
View GitHub Profile
@AlasdairWalmsley
AlasdairWalmsley / gist:69c775e8f5215a91d5c46cc355edf984
Last active Mar 24, 2020
Split Excel Table - each row of table becomes a separate sheet in your workbook
View gist:69c775e8f5215a91d5c46cc355edf984
Option Explicit
Sub Split_Excercise()
Dim wsData As Worksheet, wsNames As Worksheet, wsFilter As Worksheet
Dim Datarng As Range, FilterRange As Range
Dim rowcount As Long
Dim FilterCol As Variant
On Error GoTo progend
'******************************************************************************************************