I am having above 200 numbers each numbers having different text or names so based on the number I want to create names in separate columns in excel. I tried the VBA code but I couldn't. Please guide me
i refers to the number of row, that was 1 initially, then we move on (after applying the function the cell in that row number 1) to the next row that is i+1 (so if we were working on row number, we will move on to row number 1+1) so new i = whatever it was equal to in the last step + 1
in my code it is putting value 10 even after blank cell Any one can find out my mistake Public Sub DoWhile_Add() Dim i As Integer i = 1 Do While Cells(i, 1).Value " " Cells(i, 2).Value = Cells(i, 1).Value + 10 i = i + 1 Loop End Sub
Get Certified in Excel VBA:bit.ly/41fWeVP
Use coupon "RUclips12" to get ‘’FLAT 12%’’ OFF at Checkout.
What does i mean? is it the column?
@@ceoofbrunestud5894 it indicates row number
Your method of teaching, presentation skill, screen clarity is awesome... God bless you and keep it up
You have explained with complete clarity. 🙏🙏🙏
Best tutorial for this so far!
Hi bro your teaching skills is excellent.
You have a great teaching skill.
Thank you.
Good example.
Excellent. I don't know where my "Step into " button is but noticed F8 does the job.
Excellent ❤️❤️
amazing. thank you very much! God bless you.
Where can I buy that 6 foot touchscreen monitor?
Hello, what if we have to display the results in another new sheet and as from A2? What shall be the code plz
Thanks for this tutorial! :)
i = 1 stands for what exactly? is it the row number?
Dear sir! You explain all videos very clearily but i want to learn probgram that is use in VBA can you tell me which book or notes are helpfull
hdid the code still work if we have a number after the last 12 ?
Yes
I am having above 200 numbers each numbers having different text or names so based on the number I want to create names in separate columns in excel. I tried the VBA code but I couldn't. Please guide me
WELL DEFINED
Thank you so much
Thanks.......................................
Hi sir,
Please tell me how I get this file which you have explain.
Thanks in advance.
Hie sir
Your lecture was superb
Can u please share VB macros in PDF file...?
EXCEL-LENT!
Good
so (i,2) = B1??
ахренеть, этот индианец лучше моих преподов объяснил...
good
Variable at the beginning is equal to 1 and then i + 1. How is that possible?
i refers to the number of row, that was 1 initially, then we move on (after applying the function the cell in that row number 1) to the next row that is i+1 (so if we were working on row number, we will move on to row number 1+1)
so new i = whatever it was equal to in the last step + 1
Dear sir
Instead off adding 10, how can we do using different value
Try different things. Experiment. See what happens.
How could I get the VBA Code for this video? please paste link if feasible.
did you see i=i+1
this step is important
thanks
how to use excel formula in vba coding with using looping
Sir aap Hindi mein video banae to meri bahut help Hogi meri English bahut down hai
sir aap k paas ek hi t-shirt h kya?
t-shirt pe dhyaan mat do.
@@satishverma1130
Sir i want learn VBA please give me ur contact number
in my code it is putting value 10 even after blank cell
Any one can find out my mistake
Public Sub DoWhile_Add()
Dim i As Integer
i = 1
Do While Cells(i, 1).Value " "
Cells(i, 2).Value = Cells(i, 1).Value + 10
i = i + 1
Loop
End Sub
Sorry I found my mistake I wrote " " instead of "".There was one extra space