parse to split worksheets

M

macdca

Board Regular
Joined
Sep 28, 2010
Messages
170
I am using Jerry Boclaires macro for splitting date from one worksheet into many based on column A, but half way through there is an error with this line of code:

If Not Evaluate("=ISREF('" & MyArr(Itm) & "'!A1)") Then 'create sheet if needed

any ideas?
 

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).
You must log in or register to reply here.

Similar threads

V
  • Solved
Need VBA to split data into multiple sheets paste formulas, formatting AND data validation
Replies
2
Views
83
vanessavalentino83
V
S
  • Question Question
Parse data - Overwrite lines with updated data
Replies
0
Views
332
Scifo
S
H
  • Solved
Splitting Data into Workbooks - EDIT HELP
Replies
1
Views
287
horrellbt01
H
C
  • Solved
Split into worksheets based on multiple criteria
Replies
7
Views
184
Fuji
F
S
  • Solved
VBA Parse Data. (do not want title to copy over Every time)
Replies
2
Views
703
Scifo
S

Forum statistics

Threads
1,224,603
Messages
6,179,849
Members
452,948
Latest member
UsmanAli786

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top