so in short this is just using arrays to delete blank rows, but it would help me understand array ranges more if i could get this.
I am trying to have an array speak to another array
basically i have a sheet with lets say 1,000 rows of data and 200 of these rows has an empty value in column B
I'm struggling with the logic behind this statement
I assign an entire sheet to an array
then i want
for every 1500 rows
write those values to new sheets
include header/insert header
save as csv (comma delimited) and close sheet
next 1500 rows
This is to happen until there are no rows...