Hi,
I have this that should take the column and check if each value are greater than mx, if so then subtract bl from them and return them in new column. Then check them again and if Value is smaller than bl then change that value to bl and return in next column.
but it doesn't work and I keep getting "Invalid use of a property" error.
p.s. str supposted to count how many values are greater than mx.
Please Login or Register to view this content.
Hi
Try
Please Login or Register to view this content.
Hi (T_T),
you cannot compare the values of cells in a range in one go (except using Evaluate) but should loop through the cells instead. And I doubt the next error would occur as rows 4 and 5 are text.
Later on in the code you refer to a with statement which is not provided as well as no information about what ranges "peak shaving" and "battery" refer to and what pkSh is.
Maybe you should give this code a try:
Please be informed that the last For...Next loop clears the contents of the userform if you want further entries to be made (or simply use Unload.Me for just one entry).Please Login or Register to view this content.
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Hello.
Is the 'Maximum Power' value calculated as the largest value in column C or will you write it "by hand"?
ThanksOriginally Posted by HaHoBe
Hi (T_T),
you cannot compare the values of cells in a range in one go (except using Evaluate) but should loop through the cells instead. And I doubt the next error would occur as rows 4 and 5 are text.
Later on in the code you refer to a with statement which is not provided as well as no information about what ranges "peak shaving" and "battery" refer to and what pkSh is.
Maybe you should give this code a try:
Please be informed that the last For...Next loop clears the contents of the userform if you want further entries to be made (or simply use Unload.Me for just one entry).Please Login or Register to view this content.
Ciao,
Holger
What does this part do?Please Login or Register to view this content.
The user will give the max.
Hi (T_T),
Set the range down 2 rows and resize the range to be 2 rows short of the original range (exclude the headers) and match the number of columns.Please Login or Register to view this content.
BTW the first error was raised by
as an = was missing. Adding this will lead to a new error as your If-clauses are different from what the compiler expects.Please Login or Register to view this content.
Ciao,
Holger
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks