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!

Register Log in
  • Congratulations derfloh 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. kaplin

    Line break within an Excel formula

    Thanks! The 13 was a typo - it was the "wrap" that I didn't realize!
  2. kaplin

    Line break within an Excel formula

    I'm trying to put a line break in an excel formula in a spreadsheet. Ex. ="Hello"&Char(13)&"World" The problem is that the return shows up as a box symbol (ie does not insert the line). Is there anyway to type the formula such that excel recognizes the line break? Thanks, Christine.
  3. kaplin

    Group Box Visibility

    In excel, is it possible to hide a group box (in this case, used to group option buttons) on a form without also hiding its contents?
  4. kaplin

    Runtime Error 5981 (Could not open macro storage)

    I have a macro which opens new Word documents from different templates. With some of the files, I get this "Could not open macro storage" error. I also get the error if I open the new document manually, but the file still opens once I hit OK. Has anyone had any experience with this...
  5. kaplin

    R1C1 with Variables

    Thanks! I didn't realize there was a difference between Formula and FormulaR1C1. Changing it did the trick though..
  6. kaplin

    R1C1 with Variables

    When I do this: text = "=subtotal(9," & Chr(64 + col) & "2:" & Chr(64 + col) & lastrow & ")" where col and lastrow are integers, I get an error because it inserts single parenthesis into the formala in the cell. Ex: =subtotal(9,'A20':'B60') Any idea how I get...
  7. kaplin

    R1C1 with Variables

    When I do this: 'text = "=subtotal(9," & Chr(64 + col) & "2:" & Chr(64 + col) & lastrow & ")" where col and lastrow are integers, I get an error because it inserts single parenthesis into the formala in the cell. Ex: =subtotal(9,'A20':'B60') Any idea how I get...
  8. kaplin

    Find Method - Run Time Error

    Thanks! Looking at your code - I realized, the only thing I was missing was the word "Set" in front of the find call. It works now!
  9. kaplin

    Find Method - Run Time Error

    Given the name of the column (ie. the text in the header row), I just want to return the column number. Using this code I get an error when nothing is found. dim mycol as variant mycol = ActiveSheet.Range("1:1").find(sort_name, SearchOrder:=xlByRows).Column Is there a better way?
  10. kaplin

    Excel - using variables in object names

    Wow - and to think it sounds like such a simple question! Thanks.
  11. kaplin

    Excel - using variables in object names

    I'm new to forms - how do I use a variable when calling a series of checkboxes. Ex: dim count as integer dim titles(20) as string for count = 1 to 20 titles(count) = myForm."checkbox" & count.caption next count

Part and Inventory Search

Back
Top