bananatang
11-13-2008, 09:02 AM
Dear All,
I am finding this forum very useful and looking through posts i have learnt alot about writing macros.
I am stump in finding a workable solution to my problem and I was wondering if someone could help me with the following.
I am trying to write a macro that will perform several formatting options to cells, which contain a specific value. I have attached the macro that I have at the moment, which works fine if you are only going to perform a single formatting option, however I am looking to do various other formatting.
I have a worksheet that will contain various titles. What I would like to do is format that Title cell and 10 columns after it and add a row above it and below it and shade them and to reduce the height of the added rows.
For ease of understanding, I have created a macro called ?colourgroup? which show what I would like to happen to the cell that contains the specific cell values.
I tried using the find method, however runtime errors occur if there are no cell found.
Any help would be appreciated.
I am finding this forum very useful and looking through posts i have learnt alot about writing macros.
I am stump in finding a workable solution to my problem and I was wondering if someone could help me with the following.
I am trying to write a macro that will perform several formatting options to cells, which contain a specific value. I have attached the macro that I have at the moment, which works fine if you are only going to perform a single formatting option, however I am looking to do various other formatting.
I have a worksheet that will contain various titles. What I would like to do is format that Title cell and 10 columns after it and add a row above it and below it and shade them and to reduce the height of the added rows.
For ease of understanding, I have created a macro called ?colourgroup? which show what I would like to happen to the cell that contains the specific cell values.
I tried using the find method, however runtime errors occur if there are no cell found.
Any help would be appreciated.