You could also do the following:
Select your range (A1:D1251)
Copy
Select a new worksheet, cell A1
Right click, PasteSpecial - Transpose (at the bottom of the dialog box)
Working off IRstuff's idea, try this, it assumes that column B contains the RET values, this can easily be changed.
Sub deleteRET()
Dim strTemp As String, rngSearch As Range
Dim firstaddress As Range, lastaddress As Range
Cells.Select
Selection.Sort Key1:=Range("B1")
strTemp =...
Try this, set the scroll area when the sheet is opened. It restricts the effective size of the sheet and the operator can only use the fields you set , i.e. "a1:f10".
Add this to the "ThisWorkbook" Open Event
Worksheets(1).ScrollArea = "a1:f10"
Regards,
Dave
I found this while perusing one of my favorite sites for VB Info www.mvps.org/vbnet/
Hope it helps.
HOWTO: Create a Resolution-Independent Form
--------------------------------------------------------------------------------
The information in this article applies to:
Microsoft Visual Basic...
Gary,
I think I understand your problem and I have a solution. If you dimension the hole you use to pattern with a radial distance from the origin and an angular dimension, you can use 4 equations to define your relationships.
definitions:
W = width of rectangle
R = Radius from origin to...
Rednyx
You can set the CONTROLBOX property of the form containing you graphic to false. There may be some other properties but this one turns off the header of the form.
Regards,
Dave Wilson
There are many places to get information on the best practices and tips/tricks. Below is a link to a SW solution partner that publishes PDF files containing all kinds of information. This is where I started when I started an inter-company user group...
From SolidWork 2000 SP10 help file:
Pro/ENGINEER Files
The Add-In module SldTrans 1.0 imports a part or assembly file from Pro/ENGINEER into a SolidWorks part or assembly document. The attributes, features, sketches, and dimensions of the Pro/ENGINEER part are imported. If all of the features...
I have come up with possibly a simpler solution to your problem. My problem is the solution uses slopes and intercept information and would be difficult to explain. If you are interested in seeing the excel sheet (no macros, therefore no virus risk) I can send it to you.
A B C
1 200 400
2...
Straight from SolidWorks help files:
Pro/ENGINEER Files
The Add-In module SldTrans 1.0 imports a part or assembly file from Pro/ENGINEERÒ into a SolidWorks part or assembly document. The attributes, features, sketches, and dimensions of the Pro/ENGINEER part are imported. If all of the...
