can anybody
EXPLAIN THAT CODE SO
I CAN UNDERSTAND HOW THAT CODE WORK, I HAVE LITTLE KNOWLEDGE OF VBA
SEE THE BELOW CODE , i also attached file of that code
![]()
Please Login or Register to view this content.
can anybody
EXPLAIN THAT CODE SO
I CAN UNDERSTAND HOW THAT CODE WORK, I HAVE LITTLE KNOWLEDGE OF VBA
SEE THE BELOW CODE , i also attached file of that code
![]()
Please Login or Register to view this content.
Last edited by keshavtale; 02-25-2015 at 08:50 AM.
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.
Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.
Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here
(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)
Never use Merged Cells in Excel
sorry i dont know about that rule, now i posted that thread again can you see that
Code start from last row
Back to the 2nd row (that's why Step is -1)![]()
Please Login or Register to view this content.
And it compare current value in B column with previous one (i.e. B20 with B19)
And if they are not same it will add one more row![]()
Please Login or Register to view this content.
![]()
Please Login or Register to view this content.
if possible can you give explanation in more detail like what is i in offset(i) and every object like that, please if possible
See if this helps. I've put comments in the VBA code to explain what is happening.
![]()
Please Login or Register to view this content.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
ok now i understand thanks for that , can you suggest any book or website to learn vba for
beginners
Hi,
I like the programming and teaching style of
http://spreadsheetpage.com/
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks