Reputation
1,341
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
1 15 29
Impact
~290k people reached

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
Jan
27
comment Batch File for Download + Unzip (.7z) + Delete + Rename
Thanks for sharing the first steps, I have realized that the link for files is on internet not on intranet. So I edited my question (Step1) So I think I should use another function in order to download files from internet (asking login and password if it's not saved on cache)
Jan
27
revised Batch File for Download + Unzip (.7z) + Delete + Rename
Changed "intranet" with "internet", added more details
Jan
26
asked Batch File for Download + Unzip (.7z) + Delete + Rename
Jan
15
awarded  Notable Question
Jan
9
comment highlighting duplicate rows in excel by VBA macro
Which part do I need to edit for new colors? @Ron Rosenfeld
Jan
8
comment highlighting duplicate rows in excel by VBA macro
Works like a charm after renaming the class module.Big thanks for the code...
Jan
8
accepted highlighting duplicate rows in excel by VBA macro