Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. jawbonium

    Creating a custom data type

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

    Creating a custom data 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...
  3. jawbonium

    If/else Optional Regions in Macromedia Templates???

    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...
  4. jawbonium

    Application.ScreenUpdating not working

    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.
  5. jawbonium

    Application.ScreenUpdating not working

    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...
  6. jawbonium

    Application.ScreenUpdating not working

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

    Application.ScreenUpdating not working

    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...
  8. jawbonium

    Extra character (') in dynamically generated formula

    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...

Part and Inventory Search

Back
Top