Hi ,
I am looking for a code that will transfer the value of cells a1,b1,c1 to a7,b7,c7 automatically.
but something is terribly wrong. can something please help me .Please Login or Register to view this content.
thanks in advance.
Hi ,
I am looking for a code that will transfer the value of cells a1,b1,c1 to a7,b7,c7 automatically.
but something is terribly wrong. can something please help me .Please Login or Register to view this content.
thanks in advance.
u have written it the otherway round.Where u want should be in the bracket of range and the value u want should come after equal sign.
regards
can you please rewrite the code for me.
thanks in advance.
i have written it in the simplest of forms
regardsPlease Login or Register to view this content.
my excel stopped responding when i wrote this code.
What should I do,Please Login or Register to view this content.
thanks in advance.
Please Login or Register to view this content.
Unless you turn event handling off it will get stuck in an endless loop, as each cell update calls the change event, which updates more cells.
thanks for that @Andrew-R
regards
Last edited by vipul.halbe; 08-11-2011 at 04:03 AM.
I rewrote as you said ...Please Login or Register to view this content.
and it's working ...thanks a ton..
Last edited by fatalcore; 08-11-2011 at 04:07 AM.
hi,
i have modified the code as per my requirement.
but i want the value to two cells to be in number..any help is much appreciated.
Please Login or Register to view this content.
Please Login or Register to view this content.
Is that any closer? I've removed your error handling lines, as they weren't doing anything.
hi,
it is giving me an error...type missmatch...
OK, you're going to have to give us some clues - what is in the cells that you want to display in number format?
I have already mentioned that above,
still here is the code. I have written that in the code section --> // i want the value in ......
thanks in advance.Please Login or Register to view this content.
No, I get that you want the values in number format - what I want to know is what are they at the moment? In what way aren't they in number format? Are they strings, dates, something else?
ok, they are in present in general format.
i have used this formula in Cells(14, 6)
Please Login or Register to view this content.
and this formula in Cells(18, 6)
Please Login or Register to view this content.
OK, if you want those cells to show percentages why not use the cell formatting options to make them percentages, rather than manually adding the % sign?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks