Search results for query: *

nm..I found an answer: Type Sample One As Variant Two As String Three as Integer End Type

I used to have an example to draw upon for this, but since it's gone: I juggling multiple sets of three different variables of different data types and would much rather be juggling multiple instances of a custom data type which combines the three data types. How do I define a custom data...

I am using Dreamweaver MX 2004. I have started a template for the site. I would like to create a series of "Optional Region"s which are more than strictly boolean. Rather I would like them to be dependant upon the name of the page, displaying X1 if the page name is X and displaying Y1 if the...

Well, I have this nasty habit of cheating when it comes to formatting. I record a macro of what I want done then cut an' paste what I wanted out of it. Sometimes I tailor the generated script down, and in this instance while I trimmed it down, I didn't read it too carefully.

Well, I think I may have figured it out. This was the line that was barfing: Sheets("Summary").Range(Cells(firstEmptyRow, 1), Cells(firstEmptyRow, 11)).Borders(xlInsideHorizontal).Weight = xlThin I'm GUESSING that the reason this doesn't work is that there isn't technically an...

Thank you for the insight. Sorry about the inaccurate Subject line.

I have a pair of weird errors here. The first is an error that I get with .Borders. I pretty much gave up on trying to fix it as it really wasn't that important and it was only occuring periodically. Thus I wanted to have the .Borders line execute when it could and suppress the error message...

That worked! Thank you very much!

I am baffled. I am writing a macro to write the same forumla in the same cell in every sheet in my workbook except Summary (since the formula references the Summary sheet). Here is the script: For Each ws In ActiveWorkbook.Worksheets If (Not (ws.name = "Summary")) Then...