Generating the number of rows based on the number that a CELL has using record macros
Hi, as the title says how would one go about doing this. For instance if in a new spreadsheet Cell A2 had the number 6 in it, how do I use the record macro (with relative reference) to generate integers 1 to 6 say in cells B4 to B10. I don't want to know how to write the VBA code for this since that is straightforward.
selsunblue,
The record macro feature is going to have you end up with VBA code anyway, so i'll just provide that:
That will add numbers starting with 1 and increasing downward until it reaches the number listed in A2.
Please Login or Register to view this content.
Hope that helps.
DarkF1ame
Mark as "Solved" and add Reputation if applicable.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks