Hello,
I have a sub procedure that uses a color as an argument (ie RGB(0, 0, 0)), and then colors the selected cells:
I am given a mismatch error. I know it's possible to store shadeColor As Integer and then use 123456 as a color, but I was hoping I could use RGB instead as it makes more sense.
Please Login or Register to view this content.
Thanks
The RGB function returns a Long, not a String.
Entia non sunt multiplicanda sine necessitate
I do not understand - RGB is Long value:
call by:Please Login or Register to view this content.
for example.Please Login or Register to view this content.
- Please remember to mark threads Solved with Thread Tools link at top of page.
- Please use code tags when posting code: [code]Place your code here[/code]
- Please read Forum Rules
Thanks!
that was a silly question, wasn't it
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks