Hey Guys
I'm trying to find a code in order to find the fist available cell in row 1 and apply an index match formula in two columns from row 2 downwards.
Attached you will have 2 tabs
Before: yellow aera
After: green area is the one to achieve
many thanks!!
Last edited by antonio32; 08-20-2014 at 04:46 AM.
Range("a1").End(xlToRight).Offset(0,1)
the application.worksheetformula(same arguments as sheet)
Hope this helps
Sometimes its best to start at the beginning and learn VBA & Excel.
Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
Available for remote consultancy work PM me
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks