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 cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. FM1

    Excel Page Layout

    That was it!!! Thanks very much.
  2. FM1

    Excel Page Layout

    I have an excel sheet that I use quite a lot. When I open it on my laptop all the Vertical page brakes are where I want them to be. the "Print Preview" displays all the colors and lines..etc. However, when I open the very same file on my home desktop the page size is larger than the breakes and...
  3. FM1

    ALT Key !!

    when i disconnect the laptop from the external monitor it works fine. with the external monitor attached as soon as i reach 1 in 0178 (with alt key pressed) it only identifies the #1 monitor
  4. FM1

    ALT Key !!

    Thanks Deniel. Exactly what I thougth, it must work anywhere in a windows environment.
  5. FM1

    ALT Key !!

    windows 7 (I should have mentioned that) I am trying to use windows "Character Map" Start>>Accessaries>>system tools>>character Map i should be able to insert any character by using ALT+"Numeric code" in any windows based application. and i do it at home on W7 but somehow not on my work pc
  6. FM1

    ALT Key !!

    I am working with a new computer with 2 monitors. normally make use of the "ALT" key plus charcter codes to to superscribe the digit 2 to show a power of two, Alt+0178 will result in power of 2. on this new machine this does not work, how can i change what the "ALT" keys do??? Many thanks FM
  7. FM1

    Locating the Row Number of PageBreak

    Variables speak for themselves. spacing is along a row of piles LL is the distance from the origin of the pile row to the row in the other direction. this code works. I am trying to add a step where when the code is filling in the cells with pile coordinates it will skip 2 lines when it gets...
  8. FM1

    Locating the Row Number of PageBreak

    Thanks yogia, I tried it. It gives me a message that "Subscript Out Of Range". I am trying to use it in a loop so when the code reaches a page break on the sheet it will skip the following 2 (or n) rows and go back to doing what it, hopefully, is supposed to. Thanks again, I'll keep at it. FM
  9. FM1

    Locating the Row Number of PageBreak

    How can I locate where the horizontal page break is using a VBA code. In other word, I am trying to find where ActiviSheet.HPageBreaks(2).Location is. When you set up the page break the syntax is ActiviSheet.HPageBreaks(2).Location = Range(Col, Row) Col is always "A" I want my macro to...
  10. FM1

    Page breaks on worksheet and Macros

    I have a worksheet with page break view. I want to be able to have a macro recognize the begining and end of each page and write info to the pages begining at the top of each page. Can this be done? Thanks
  11. FM1

    IMPORT OF BLOCK FROM AUTOCAD 2005

    I do this often with sketches in my calc sheets, as johnwm said, in autocad, under "File" click "export" chose your item(s) and save as wmf file in your excel file insert as picture from file and crop and resize resize from corners so the original aspect ratio is maintained I hope this helps
  12. FM1

    Last Cell in a Named Range

    Thank you
  13. FM1

    Last Cell in a Named Range

    Hello everyone, How can i reference the last cell in a named range of cells? I have a range, it is a part of one column, it is named say, "XYZ" I can get to the vaious cells by using Range("XYZ").Cells(i) how can I, Or, Can I, reference the last cell in the range right off the bat, somehow...
  14. FM1

    Replacing Parantheses with Brackets

    Hello everyone! Assuming that we have mathematical expression with several parentheses, how can a macro be written to pick up the string and replace second level parentheses with square brakets and the higher levels with curly brackets. I have exhausted what little programing knowledge I have...
  15. FM1

    VBA Module Protection by hiding or password

    Thank you
  16. FM1

    VBA Module Protection by hiding or password

    I have asked this question before, and, the one or two responses given were general though much appreciated. How can I protect the code in ONE single module from being accessed and viewed by the user in an EXCEL workbook and still have the VBA editor and other modules accessible. Can a single...
  17. FM1

    File size question

    I worked on a workbook with some number and cell formats then erased all that info. now my workbook has only about 2 8.5x11 sheets worth of info in it but the size of the file is on the order of 650kb. when I copy and paste the same info to a new file the size reduces considerablly down to about...
  18. FM1

    Getting rid of Macros

    you can copy your file sheet by sheet into a new excel file and delete the old one, it worked for me.
  19. FM1

    Greek Letters in Modules

    Also, when I select the character "Pi" from character map to copy it to the VBA module I end up with a question mark in the module when i click the past button. Am I missing something?
  20. FM1

    Greek Letters in Modules

    Thanks very much sdz and pmover, sdz, very helpful pointer. I cant however find an "Alt+..." keystroke for the greek letter "Pi". Am I missing it? It seems that only some of the characters have the "Alt+..." keystroke associated with them. Thanks again

Part and Inventory Search

Back
Top