Sound Science

Comment from caenies
Time June 1, 2011 at 9:59 am

Parceros muchas gracias, gracias a este tipo de videos tengo un excelente trabajo, estoy haciendo mas dinero en menos tiempo, soy mas eficiente en mi labor y lo mejor de todo tengo mas tiempo para mi ya que dejo que las maquinas trabajen y no tuve que gastar un dolar en el aprendizaje. hey PAL thanks a lot.

Comment from caenies
Time June 1, 2011 at 10:36 am

Parceros muchas gracias, gracias a este tipo de videos tengo un excelente trabajo, estoy haciendo mas dinero en menos tiempo, soy mas eficiente en mi labor y lo mejor de todo tengo mas tiempo para mi ya que dejo que las maquinas trabajen y no tuve que gastar un dolar en el aprendizaje. hey PAL thanks a lot.

Comment from profaisnol
Time June 1, 2011 at 10:55 am

AWesome

Comment from profaisnol
Time June 1, 2011 at 11:29 am

AWesome

Comment from ExcelVBAHelp
Time June 1, 2011 at 11:30 am

@Because011 I will put up a video soon about using vlookups in code. Subscribe and stay tuned!

Comment from Because011
Time June 1, 2011 at 12:02 pm

Do you have any Video where You have have created a macro to Use Vlookup/Match between 2 workbook.

Thanks

Comment from Because011
Time June 1, 2011 at 12:43 pm

Thank you so much. I have search and search to get what I want and you did if for me.
A+++++++++++++++++

Comment from mveeramurali
Time June 1, 2011 at 12:59 pm

superb,,,,

Comment from ExcelVBAHelp
Time June 1, 2011 at 1:37 pm

@kaptkirk7 — try .End(xlup).Select NOT “x1″

Comment from kaptkirk7
Time June 1, 2011 at 2:31 pm

Good presentation..in my practice line;
Range(“a65000″).End(x1up).Select
keeps hosing when I step through the code. I’m using EXCEL 2003, how can I correct this?

Comment from MrKevin010
Time June 1, 2011 at 3:24 pm

Very nice! like how you have errors and explain why…

Is there a way to download the spread sheet (For us lazy people) so we can play with it?

Again very good, I want to do the same thing but activate the cell and perform a function 10 cells over for every incident that occurs i.e. the word DOG…. THANKS.

Comment from samolee1103
Time June 1, 2011 at 4:15 pm

Thanks a lot, it is very useful

Comment from almalhoum
Time June 1, 2011 at 4:27 pm

thanks man, this sa big help

Comment from nadirvirk
Time June 1, 2011 at 5:26 pm

Really Good! appreciate!

Comment from gateway123qwert
Time June 1, 2011 at 5:27 pm

Very well explained

Comment from ducksaj
Time June 1, 2011 at 5:58 pm

Hi, could plz help me, I am trying to create a macro to run automatically everytime I change the cells value like ” if range (“E7″) = “cnh” then” I want to execute the macro if E7 = “cnh” or else exit sub. I hope you have understood me, thank you so much

Comment from MrAvv433247
Time June 1, 2011 at 6:13 pm

Nice tut!!!!

Comment from tbeszcz
Time June 1, 2011 at 6:40 pm

Thanks Dude, I’m just starting with VBA macros and those tutorials are a great help. Apreciate it !

Comment from Joeykaos
Time June 1, 2011 at 6:49 pm

Great piece of code, I used a different method but yours is more efficient. Thank you!

Comment from ROB4MAY
Time June 1, 2011 at 7:00 pm

Like the tutoral
but in my 2007 i get and error at second round on this line ;If Cells(xrow, 1).Value = “” Then
Can you help me get past this??

Comment from nagendrajayanty
Time June 1, 2011 at 7:46 pm

Thanks a lot for the demo… and for your information… dim represents dimension if i am not wrong!!

Comment from ellennetube
Time June 1, 2011 at 8:17 pm

An improvement to the readability of the code could be :

xlastrow = Range(“a65000″).End(xlUp).Row

In this way the value of this variable is 14 in your case and you can easily. If you set a viewer on your variable its value is -1 and in my case instead it is 14

Comment from dnejeff
Time June 1, 2011 at 8:58 pm

Good Job on the Video. I appreciate it!

Comment from shvanvasu
Time June 1, 2011 at 9:34 pm

very nice and understandable and Video, audio quality also too good

Comment from waltzip2009
Time June 1, 2011 at 9:55 pm

very nice…. i have learned a lot dude!