I need help writing a VBA code for this. A macro that reads a list of numbers from a given table and writes these numbers into a single dimension array. We do not know how many numbers there are in the table but the user selects the first number and then runs the macro. Help would be appreciated and I think we have to incorporate loops in the answer?
Hello liudingding,
Since I can think of several answers to this problem, I suggest that you post examples of the data and provide any comments needed to explain what you want. Posting your workbook would be the best option.
To Attach a File:
- Scroll down to the window below your post Additional Options
- In the frame Attach Files you will see the button Manage Attachments
- Click the button.
- A new window will open titled Manage Attachments - Excel Forum.
- Click the Browse... button to locate your file for uploading.
- This will open a new window File Upload.
- Once you have located the file to upload click the Open button. This window will close.
- You are now back in the Manage Attachments - Excel Forum window.
- Click the Upload button and wait until the file has uploaded.
- Close the window and then click Submit.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks