Hello experts,
I was wondering if we can program a macro to:
1) Insert a row above the current cell selected, and then filling a single space in the first 24 cells of the row.
2) Insert a column above the current cell selected, and then filling a single space in the first 100 cells of the column.
If you give me the code for 1 and 2, I will probably be able to make the third macro which does both of the above.
Thanks.
Charles.
This is a little confusing.
What does this mean? Filling with what?filling a single space in the first 24 cells of the row
Columns can't be above - do you mean to the left or right?Insert a column above the current cell selected
Not sure if this is what you're after, but making some assumptions it might work. This code inserts a row above the current cell then inserts a space character into columns A:X of that new row. It then inserts a column to the left of the active cell and inserts a space character in the first 100 cells in that column.
If that's not what you're looking for you will need to provide more details.
Please Login or Register to view this content.
Thanks PjoAcquin. It worked. But i want to ask this:
Why does running this macro twice give error?
Is it because there is no blank cell to select?Please Login or Register to view this content.
How can I modify the code so that I don't get an error if I repeat run the macro.
Best,
Charles.
Last edited by VBA Noob; 11-06-2008 at 04:08 PM. Reason: Added code tags as per forum rules
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks