Sub is in the wrong place. Step through the code to test it.
Look up the Integer and Long data types, also Single and Double.
Also look at Public Variables.
Sub is in the wrong place. Step through the code to test it.
Look up the Integer and Long data types, also Single and Double.
Also look at Public Variables.
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Posting Permissions
Reply With Quote