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 Types    Gross Building Area Scheme Types  Area Type Selected Bordering Area Type Measurement Rule   Gross Building Area  Gross Buil








Read more










Powerpoint countdown and current time in slides VBA





















Add text fields- this VBA searches through the objects in the first frame until it finds " " in the text some where, truncates everything from  and to the right and replaces it with an active countdown timer or current time in the box.   Refreshes every 500ms with a prtsafe call so it doesn't bog down the CPU. Add a slide advance to start the next slide and begin automated slide advancement.          Attribute  VB_Name  =  "Countdown"  Private  Declare  PtrSafe  Function  WaitMessage  Lib  "user32"  ()  As  Long   Public  Sub  Wait ( Seconds  As  Double )  ''non cpu-intensive wait timer '' https://stackoverflow.com/questions/57268161/sleep-wait-timer-in-powerpoint-vba-thats-not-cpu-intensive      Dim  endtime  As  Double      endtime  =  DateTime.Timer  +  Seconds      Do          WaitMessage          DoEvents      Loop  While  DateTime.Timer  <  endtime   End  Sub    Sub  Countdown_from_Start ()  Dim  Time  As  Date  Dim  Count  As 








Read more










Revit 2019 and up tab colorizer





















 PYRevit works to tip the tabs tops with a color but not the whole tab so it is not as obvious as I would like but definitely better than nothing!     Py revit version is free and available here:   https://github.com/eirannejad/pyRevit/releases/tag/v4.7.6     Parallax has an independent Addin as well:   $75 Seat or $1500/site license annual.   https://www.parallaxteam.com/tabbed-views/      There may be some customization in the API available hereabouts : )   https://thebuildingcoder.typepad.com/blog/2011/02/pimp-my-autocad-or-revit-ribbon.html     








Read more