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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.