Is there any webpages or public docs where I can get a class breakdown
of all
Excel functions/variables in VBA? Specifically the cell style
variables? I've been unsuccessful in just playing with different
values and getting the results I need. (Things like cell boarders,
removing column/row lines etc etc)

Also I'm looking for a way to get the exact number of items in a
column and a way to completely clear a sheet. I'm currently performing
a

for i = 1 to width
Excel.Activeworkbook.Sheets("SHEETNAME").Columns(i ) = ""
next i

however it doesn't remove formatting information like boarders


Thanks
Eric