O
Offace
Hello MS Excel Newsgroup,
I have constructed (well almost) an application using Microsoft Excel 2007 SP2,
VBA, on Windows XP Pro SP3. There are two Worksheets which one is used to store
12 (small) matrices of numbers, each matrix encapsulated in it's own named Range.
The other Worksheet contains user controls which the user can select a few
predefined values that, kick various VBA routines off, and display the results on
a Graph, on the user's Worksheet (and a few other results).
The user would like to see the underlying matrix on their Worksheet. Given the
parameters the user chooses, I can set a named Range on the user's Worksheet to
the exact dimensions of it's data matrix, on the other Worksheet.
Learning that;
UserSheet.Range("DataDump") = MatrixSheet.Range("MatrixData")
- nor -
UserSheet.Range("DataDump").Value = MatrixSheet.Range("MatrixData") .Value
- nor -
UserSheet.Range("DataDump").AnythingElsePertainingToValueOrObject =
MatrixSheet.Range("MatrixData") .AnythingElsePertainingToValueOrObject
work, is there any 'innate' functionality in Excel that permits this?
Is looping or Array assignment to the range the better way of approaching it?
I have constructed (well almost) an application using Microsoft Excel 2007 SP2,
VBA, on Windows XP Pro SP3. There are two Worksheets which one is used to store
12 (small) matrices of numbers, each matrix encapsulated in it's own named Range.
The other Worksheet contains user controls which the user can select a few
predefined values that, kick various VBA routines off, and display the results on
a Graph, on the user's Worksheet (and a few other results).
The user would like to see the underlying matrix on their Worksheet. Given the
parameters the user chooses, I can set a named Range on the user's Worksheet to
the exact dimensions of it's data matrix, on the other Worksheet.
Learning that;
UserSheet.Range("DataDump") = MatrixSheet.Range("MatrixData")
- nor -
UserSheet.Range("DataDump").Value = MatrixSheet.Range("MatrixData") .Value
- nor -
UserSheet.Range("DataDump").AnythingElsePertainingToValueOrObject =
MatrixSheet.Range("MatrixData") .AnythingElsePertainingToValueOrObject
work, is there any 'innate' functionality in Excel that permits this?
Is looping or Array assignment to the range the better way of approaching it?