missprogrammer
Programmer
DarkSun no I dont. Not only That how would i specify only the to incude the next 3 columns. I dont want to shade in anything outside of the range
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
DarkSun (Programmer) Please Reply
- Thread starter missprogrammer
- Start date
- Status
Can we try and keep this on one thread please.
Before I believe you said you knew the first column, which I think was x?
So I think working with your code. If x is the first column then you want to change color in next three columns so you run this.
Call ChangeColor(x+1,100)
Call ChangeColor(x+2,100)
Call ChangeColor(x+3,100)
Where 100 is the number of rows you want to check.
Before I believe you said you knew the first column, which I think was x?
So I think working with your code. If x is the first column then you want to change color in next three columns so you run this.
Call ChangeColor(x+1,100)
Call ChangeColor(x+2,100)
Call ChangeColor(x+3,100)
Where 100 is the number of rows you want to check.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question