• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Shortcut While Paste

Istiyak

Istiyak

Member
Namaste Team,


Have uploaded one small pic on my website


www.istiyakshaikh.hpage.com > dowloads > shortcut


Can any one give me if any shortcut for that ??


Help Appriciiiiattteedd ??


Regards

!$T!
 
Hi ,


What you can do is put in the following VBA statement in a macro and assign any shortcut key ( CTRL SHIFT key ) to it :


ActiveCell.Value = Val(Activecell.Value)


For example if you assign the key R to it , then placing your cursor in the cell , whose contents you wish to convert to a number , and pressing CTRL SHIFT R will do the job.


Narayan
 
Thanks Narayan,


Its Working with just an active cell not with selected range.


I want some vba which can work with range.


Regards

!$T!
 
Hi, Istiyak!


Just replace the code by this:


-----

For Each cCell In Range("A1:B2")

cCell.Value = Val(cCell.Value)

Next

-----


And add at the top somewhere:


-----

Dim cCell as Range

-----


Regards!
 
You must log in or register to reply here.
Back
Top