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!
-
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...- NOEd
- Thread
- Replies: 1
- Forum: -Engineering spreadsheets
-
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 =...- NOEd
- Thread
- Replies: 0
- Forum: -Engineering spreadsheets
