Basic excel parametric sweep
Basic excel parametric sweep
(OP)
Hello colleagues
I have a range of cells with input data. For each of it i want to put corresponding value into a calculations sheet and store the result into new range - how to do that with VBA ?
thanx and kind regards
I have a range of cells with input data. For each of it i want to put corresponding value into a calculations sheet and store the result into new range - how to do that with VBA ?
thanx and kind regards





RE: Basic excel parametric sweep
Sub CopyData()
Range("TargetRangeName").Value = Range("SourceRangeName").Value
End Sub
If you want to do something more complicated, can you provide more details.
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
RE: Basic excel parametric sweep
RE: Basic excel parametric sweep
You haven't helped yourself with your statements. Can you upload your workbook or at least post an example that illustrates your problem?
Skip,
Just traded in my OLD subtlety...
for a NUance!
RE: Basic excel parametric sweep
TTFN (ta ta for now)
I can do absolutely anything. I'm an expert! https://www.youtube.com/watch?v=BKorP55Aqvg
FAQ731-376: Eng-Tips.com Forum Policies forum1529: Translation Assistance for Engineers Entire Forum list http://www.eng-tips.com/forumlist.cfm
RE: Basic excel parametric sweep
RE: Basic excel parametric sweep
RE: Basic excel parametric sweep
RE: Basic excel parametric sweep
I agree that the Data Table feature is probably the easiest option, but another way to go if you are happy with VBA is to create a User Defined Function which is entered as an array formula. That can then return an array of any required size.
As Skip said, an example workbook showing what you have so far would be helpful.
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/