Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Prob with Var Data-types..
I have this macro to assign rows with data headers to the variable HderRows
- I want to return HderRows as a Row number or Cell though can't get it to work..missing something here about Object variables or something. - Not sure why Dim HderRows () doesn't allow empty parenthesis. Understand this should give a variable array (though 15 is a reasonable max anyway). Thanks M. Dim HderRows(15) As String NoHderRows = 1 Do Until IsEmpty(ActiveCell) ActiveCell.Offset(CntMon + 5, 0).Select Loop NoHderRows = NoHderRows - 1 'Defines HeaderRows Range("B3").Select For j = 1 To NoHderRows HderRows(j) = ActiveCell.Value ActiveCell.Offset(CntMon + 5, 0).Select Next j |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 error "some chart types cannot be combined with other chart types. Select a different chart types" | Charts and Charting in Excel | |||
Prob with ChartSource DataData Range | Charts and Charting in Excel | |||
Data types when importing Excel data to SQLServer | Excel Discussion (Misc queries) | |||
Urgent! Prob with Excel 2002 Template Wizard with Data Tracking ad | Excel Discussion (Misc queries) | |||
Importing data from Access into Excel: prob w/ cutting off fields | Excel Worksheet Functions |