Reputation
1,373
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
1 16 31
Impact
~330k people reached

Aug
14
revised How do I create the GodMode folder in Windows 7 & Windows 8?
added win10 compatibility comment
Aug
10
awarded  Notable Question
Jul
20
awarded  Popular Question
Jul
10
comment Transforming Color Codes in VBA
Works fine, thanks for the tip...
Jul
10
accepted Transforming Color Codes in VBA
Jul
10
asked Transforming Color Codes in VBA
Apr
23
awarded  Popular Question
Feb
27
answered Excel Opening as a blank spreadsheet, but with values
Feb
20
comment highlighting duplicate rows in excel by VBA macro
Ok got it now :) I can use lots of rgbXxxx colors now.Big thanks again...
Feb
20
comment highlighting duplicate rows in excel by VBA macro
hmm I understood finally :), I will check google for a complete list of colors to add in code's "arrColors = VBA.Array(vbRed, vbCyan, vbYellow, vbGreen)" field.
Feb
20
comment How do I reconnect an already mapped network drive from command prompt
This is the only code that worked for me.
Feb
20
comment highlighting duplicate rows in excel by VBA macro
Here is the example pattern to be checked for duplications. I created the macro inside this file as well. yadi.sk/i/okjRajjeeoKHH @Ron Rosenfeld
Feb
20
comment highlighting duplicate rows in excel by VBA macro
Let us continue this discussion in chat.
Feb
20
comment highlighting duplicate rows in excel by VBA macro
Yes, I use your updated code. @Ron Rosenfeld
Feb
20
comment highlighting duplicate rows in excel by VBA macro
In fact 10 different colors are enough for me but when I run the macro it repeats the colors after 4. @ Ron Rosenfeld
Feb
20
comment highlighting duplicate rows in excel by VBA macro
even after updating the code for arrColors part of the code, I don't have enough colors to highlight different matching pairs. Any other way for doing this color numbers increase? @Ron Rosenfeld
Jan
28
comment Batch File for Download + Unzip (.7z) + Delete + Rename
Thank you @Tyler for your fast solutions. I just have downloading issue to be solved, I'm trying to understand wget structure but did not succeed yet.
Jan
27
comment Batch File for Download + Unzip (.7z) + Delete + Rename
Yes, that's why I've added a comment under the question.I don't know why the renaming code does not work with " - " sign? Which part of the code do I have to change to rename FILE-Date?
Jan
27
comment Batch File for Download + Unzip (.7z) + Delete + Rename
I've started by renaming function. Your rename code works fine with "" delimiter but when I try to use it with "-" delimiter it does not work, do I make sth. wrong? Just replaced "" by "-" in the code --> for /f "tokens=1,2 delims=-" %%A in ('dir /b *.mdb') do ren %%A_%%B %%A.mdb
Jan
27
revised Batch File for Download + Unzip (.7z) + Delete + Rename
added 101 characters in body