Forums
New posts
Articles
Product Reviews
Policies
FAQ
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Menu
Log in
Register
Install the app
Install
Forums
Apple Computing Products:
macOS - Apps and Programs
Convert Excel VB script to Applescript?
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="pingwin77" data-source="post: 685423" data-attributes="member: 60117"><p>I suppose it might help to mention what the macro does. It basically copies data and appends it to a list that is a bit further down the page.</p><p></p><p>1. Copy row 2 which contains about 15 formulas.</p><p>2. Pastes special / values only into row 3.</p><p>3. Copy row 3</p><p>4. Starting with row 5, look down the page for the next empty row.</p><p>5. Paste the data from row 3 into the next blank row.</p><p></p><p>I hope this helps.</p></blockquote><p></p>
[QUOTE="pingwin77, post: 685423, member: 60117"] I suppose it might help to mention what the macro does. It basically copies data and appends it to a list that is a bit further down the page. 1. Copy row 2 which contains about 15 formulas. 2. Pastes special / values only into row 3. 3. Copy row 3 4. Starting with row 5, look down the page for the next empty row. 5. Paste the data from row 3 into the next blank row. I hope this helps. [/QUOTE]
Verification
Post reply
Forums
Apple Computing Products:
macOS - Apps and Programs
Convert Excel VB script to Applescript?
Top