How do I set the Range for a sheet function using the location of the overall function input? I've included a screenshot of my code below. I'm trying to set the range of the Product Function according to the location of the initial function input "inventoryType".
Capture.PNG
I'm not clear on the wording of your question but I think you just want this:
A screenshot of code is not particularly useful. It's easier to just copy the code and paste it into your post. That way we can try to compile it, run it, and edit it. Use CODE tags when pasting code. There are two ways to add code tags. One is to select the code part of the text so it is highlighted, then press the "#" button in the edit controls. The other is to simply type in the tags:
Please Login or Register to view this content.
[code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code]
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
Included the code below. To reword my question, how do I turn Cells(j-1, k+3), Cells(n, k+3) into a Cell Range (e.g. A1:A5) for the WorksheetFunctionProduct() to use?
Please Login or Register to view this content.
Can you upload the spreadsheet, and describe what is happening, as well as what you want to happen?
Just looking at the code, I don't see why it wouldn't work as is.
Where can I upload the Excel Spreadsheet so I can link it? I don't see an attachment option on this post.
Click on 'Go Advanced', and you should then see a paperclip icon for uploading.
The paper clip icon does not work for attachments. To attach a file, under the text box where you type your reply click the Go Advanced button. On the next screen scroll down and click on Manage Attachments, which will show a pop-up window to Select and Upload a file. Then close the window.Originally Posted by mgs73
You are already using a perfectly good range for Product to use.
Range(Cells(j - 1, k + 3), Cells(n, k + 3))
Not a thing wrong with that.
Alright you're right, there was nothing wrong with the equation. I declared my variables incorrectly. They were all long, so I kept getting an integer output, instead of the decimals I needed. I assumed that I just built the equation wrong, when in fact, I just had to change my variables to doubles. Thanks for the help guys!
Oh, since it's my first solved post, how do I set the tag to [SOLVED]?
Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."
If you need a real result, then the only thing you should change to Double is the return type for the function. All your local variables should still be Long.
Yup that's what I did, thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks