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!

  • Congratulations TugboatEng 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: *

  • Users: NOEd
  • Content: Threads
  • Order by date
  1. NOEd

    Wind Rose

    Ever need a wind rose? Here's a start: 'This routine inserts a new worksheet and draws a series of shapes to create 'a basic wind rose, which is a figure showing wind direction, frequency, and speed. 'Input data has the form: ' 1 4 6 ... ' 2 0.01% 0.01% 0.00% ... ' 5...
  2. NOEd

    Clearing indirect references

    It can be a nusiance to copy eqns from cell to cell so this sometimes helps: 'Changes a cell to read the same as the cell it's refering to Sub ClearIndirectRef() With Selection FRow = .Row RowCt = .Rows.Count LRow = FRow + RowCt - 1 FCol = .Column ColCt =...

Part and Inventory Search

Back
Top