5/10/2012 8:16 AM | |
Joined: 10/3/2010 Last visit: 4/29/2024 Posts: 1552 Rating: (188) |
FAQ |
B r g d s , |
|
5/10/2012 8:59 AM | |
Joined: 10/3/2010 Last visit: 4/29/2024 Posts: 1552 Rating: (188) |
Can't you create this comparison and highlighting in Excel directly? |
B r g d s , |
|
5/12/2012 5:04 PM | |
Joined: 11/4/2011 Last visit: 12/8/2023 Posts: 253 Rating: (53) |
Hello Raj@SIEMENS, very interesting topic you created! I've just tried your solution and everything works fine for me. I think you forgot to define some variables. If so, your script won't work at all, though it will be compiled. Check this out, maybe you forgot to write just Dim i, a, b And don't forgot to update the screen if you are changing the script while Runtime is started. _________ There is one nuance with that Usedrange property: The row count begins from the first filled (not blank) row. And the column count - from the 1st filled column. So be careful and good luck! |
This contribution was helpful to1 thankful Users |
Follow us on