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