hello
i m working in range C10:C500, i want if i have data in range C10:C25 then select this range(C10:C25) and edit the cells(we done in excel using f2 and Tab) one by one
i mean i want to activate all range data one by one
what i want, this is only example not recorded macro
Please Login or Register to view this content.
Last edited by HaroonSid; 05-03-2014 at 03:03 AM.
Hi, haroon2015,
could you be more specific about the editing, what exactly do you want to do?
Ciao,Please Login or Register to view this content.
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
hello HaHoBe
ur code is working as what i want, need some changes
1 = range should select automatically my working range is C10:C500,
2 = InputBox is asking for evrytime to edit the cell one by one,I have data in C10:C100 then auto select the Range by InputBox=C10:C100
thanx aloti want to edit all selected range at once
Hi, haroon2015,
maybe like this:
Ciao,Please Login or Register to view this content.
Holger
nope working
this code is replacing all text to with C10.value
i mean if c10 = abc
then c10:c50 = abc
Hi, haroon2015,
First code did that.edit the cells(we done in excel using f2 and Tab) one by one
then c10:c50 = abcCiao,Please Login or Register to view this content.
Holger
leave the new one code HaHoBe
with this one i m happy(this will take lots of time to complete the task)
thanx for ur hard work thanxPlease Login or Register to view this content.
will add u reputaion
and dear will u plz look at this thread also
http://www.excelforum.com/excel-prog...an-0-zero.html
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks