Yay! We’re back – New design!
After 2-3 years, we’ve finally brought Automate Excel into the 21st century with a brand new CMS and design. The website is now powered via WordPress and doing great. The current design is probably only temporary, while we get a designer to do something special, so give us some feedback.
Anyways, here are some of the most viewed articles:
- VBA: Find Text in a String (instr) – 79,600 views
- VBA: Yes or No Message Box – 75,799 views
- 52 Excel Games – 64,267 views
- VBA: Color Reference For Colorindex – 51,507 views
- VLOOKUP Function Example – 46,399 views
- VBA: Cut, Copy, Paste from a Macro – 39,480 views
- Connect Excel to Mysql Database – 37,088 views
- Google Maps In Excel – 31,703 views
- VBA: Count the Number of Used Rows – 29,406 views
- VBA: Loop Through a Range – 25,727 views


dear sir,
in the first example, you forget to put the End Sub at the end of the program.
I learn something from this program. Thanks
Hi,
How to manually increment while using FOR EACH?
e.g.
for each cell in range(abc)
if cell.value = “YES” then
–>{increment cell = cell + 5}
end if
next
we do it in normal FOR loops
like.. if {something} then i = i+5
I would like to achieve the same while using the FOR EACH loop
thanks in advance!
Rishi
Please give me the code to populate the recordset data into the excel file,where record set is having the data of 80,000 rows and having 500 columns.
Please help me.
Thanks