Selecting a Range of Cells Relative to the Current Cell (Microsoft Excel)

Selecting a Range of Cells Relative to the Current Cell (Microsoft Excel)



Range(Cells(Selection.Row, 1), Cells(Selection.Row, 3)).Select







































Comments











Post a Comment



















Popular posts from this blog









Revit area plans adding new types and references (Gross and rentable)




















Image







Note to self: 
 
Add additional (duplicate) gross area and net area schemed under Area Plans 
 
 
And Area schemes... Really counter-intuitive place to put this instead of say...  
Area Plans> New Type> Edit Type (ADD) 
or Create an area plan, then Go to Properties, Edit Type and Duplicate... 
 

Always seem to forget this one!

2015-10-16-And for the calculation type...

To update: this also applies to Revit as well as LT-


The gross calculations cannot be overridden, however the 'rentable' comes in various flavors... From AD Revit help:

Applies to Revit LT 2015

Rules are determined by one type of space bordering another space.

The following table shows area measurement rules. To find the appropriate measurement rule, find the selected Area Type and the corresponding Bordering Area Type. 
Gross Building Area Scheme TypesGross Building Area Scheme TypesArea Type SelectedBordering Area TypeMeasurement RuleGross Building AreaGross Building AreaNoneArea Boundary measured to the outside surface…








Read more










Revit  Floor patterns and materials




















Image







Kristine and I worked this out a little farther... 
Set the offset height when creating a new floor to 1/4" (element properties in the toolbar- not the option bar) and it will remain 'sticky' - i.e. upon finishing the floor, creating a new floor will retain that value. This offset allows shading of the materials to show when the plan is "viewed in shade mode with edges".. Different colors for the shading and surface patterns drive how the element displays- particularly the hidden line and shaded views. If the floors are co-planar (i.e. the offset is not set) materials will not tag correctly in plan(not even with tabbing.) and solid patterns get lost. (Note the solid hatch pattern + color will override the shading color!) Sheets can be created in color, and printed in either color or grayscale to easily identify layouts of materials on the floors- no more cryptic hatches! 


 Maybe we should do a lunch and learn for this or a Revit session? The process has been revised (…








Read more