View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
dbfoxnh dbfoxnh is offline
external usenet poster
 
Posts: 1
Default Using ShadeAlternate Subroutines as Macro

I located the exact tip I was looking for in ExcelTip for shadin
alternate rows. What I need to do is select the rows and columns
want shaded and then call a macro to do the job. I found the tip a
the following URL:

http://www.exceltip.com/st/Row_and_c...Excel/488.html

For me, the problem is that they are written as subroutines tha
require arguments to operate. Can someone help me, first time usin
VBA in Excel, to come up with a way to allow me to use the subroutin
to shade the rows in the area that I highlight?

Exceltip.com is a great resource. Not sure why I hadn't found i
before!

Thanks!

Davi

--
Message posted from http://www.ExcelForum.com