Hi Guys
I hope to get a bit of help, even a start up would be great..thanks
All I wanted to know was if there is a function to repeat a command multiple times down the rows?
Thanks a lot![]()
Hi Guys
I hope to get a bit of help, even a start up would be great..thanks
All I wanted to know was if there is a function to repeat a command multiple times down the rows?
Thanks a lot![]()
You need to be specific in describing what you want to achieve. In terms of VBA, repeating commands is usually done by using loops.
thanks for your reply
i have 5 rows for each name from which i generated those graphs
for example
James
Row 1
Row 2
Row 3
Row 4
Row 5
John
Row 1
Row 2
Row 3
Row 4
Row 5
So the data in each row changes however, the names of the rows do not change
so i want a code that would allow me to produce the exact same graph for john that i produced for james..and there are about a thousand names and so many more worksheets so i want it to be done automatically. that is what i meant by repeating a command multiple times down the row for each set of name.
There is a filtering option for the names column but not for rows.
so if the items are filtered, it should still produce graphs till the time it find some empty cell.
I was thinking of using,this
for i = 1 to 53
...do your code
next i
But i am not sure
I hope you understand what i mean???!.. please let me know if you dont
thanks again
Last edited by mej; 12-10-2013 at 11:47 PM.
Unfortunately, it's still not very clear. It would be good if you can post a sample of your workbook.
What graph are you talking about?
Are the 5 rows going to be inserted by the macro or are they already existing data?
How are the newly created graphs going to be placed?
This is hard to be visualized without looking at sample data.There is a filtering option for the names column but not for rows.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks