Hi excel help,
I'm looking for a VBA that would allow me to add X amount of rows and those rows would be alternate highlighted between light gray and white. So for example if i clicked the macro a box would pop up asking how many rows i need and if i entered 20, then i would populate 20 rows all alternately coloured (even grey, odd white, except the top row). Thankyou so much in advance.
Johnny
Hi Johnny,
Welcome to the Forum!
Try this:
Directions for running the routine(s) just supplied
Please Login or Register to view this content.
If you haven't used macros before you'll need to go to your options - trust center -trust center settings - macro settings
, the second option down (disable all macros with notification)
Then - Copy the code to the clipboard
Open your Workbook
Press ALT + F11 to open the Visual Basic Editor.
Select "Module" from the Insert menu
Type "Option Explicit" then paste the code under it
With the cursor between Sub and End Sub press F5 (F8 to Single Step)
OR
Press ALT + Q to close the code window.
Press ALT + F8 then double click on the macro name
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
thank you very much for your speedy reply. I will try this right away.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks