+ Reply to Thread
Results 1 to 3 of 3

VBA code for copy paste data to active cell

  1. #1
    Forum Contributor
    Join Date
    03-13-2013
    Location
    india
    MS-Off Ver
    excel 2010
    Posts
    425

    VBA code for copy paste data to active cell

    In the attached file in E column you find this names "AKOLA-MANDI, KARANJA-MANDI ,KHAMGAON MANDI, MANGARULPIR MANDI ,AMARAVATI MANDI"
    if i want to copy one of that five names for example i want to copy AKOLA-MANDI to any active cell or suppose cell E44 in before sheet
    which i mentioned in attached file, it means when i press key combination ctrl+l then copy paste AKOLA-MANDI to active cell,
    when i press key combination ctrl+t then copy paste AMARAVATI MANDI to active cell,
    when i press key combination ctrl+k then copy paste KARANJA-MANDI to active cell,
    when i press key combination ctrl+h then copy paste KHAMGAON MANDI to active cell,
    when i press key combination ctrl+m then copy paste MANGARULPIR MANDI to active cell,
    so please provide VBA code for above operation
    Attached Files Attached Files

  2. #2
    Forum Expert BMV's Avatar
    Join Date
    01-13-2020
    Location
    St-Petersburg, Russia
    MS-Off Ver
    2013-2016
    Posts
    1,329

    Re: VBA code for copy paste data to active cell

    I a not sure that past to the any active cell on the sheet is good idea. I prefer to check range or any other condition. However
    ThisWorkbok module
    Please Login or Register  to view this content.
    Module
    Please Login or Register  to view this content.
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    03-13-2013
    Location
    india
    MS-Off Ver
    excel 2010
    Posts
    425

    Re: VBA code for copy paste data to active cell

    Thanks my problem is solved
    Last edited by keshavtale; 01-25-2020 at 04:33 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 4
    Last Post: 07-03-2015, 04:27 AM
  2. [SOLVED] Copy and Paste in active sheet VBA code
    By raw_geek in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-09-2014, 04:43 AM
  3. [SOLVED] Active Cell Copy and Paste
    By darias in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-30-2014, 04:30 PM
  4. [SOLVED] Code to copy data from a closed workbook and paste in active workbook using named range.
    By paullie1912 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-28-2014, 02:38 AM
  5. [SOLVED] How to paste from other sheet to active cell VBA code
    By herukuncahyono in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-11-2013, 02:49 AM
  6. Code to Read/Copy Data from Closed Wb and Return/Paste in Active Wb
    By AlvaroSiza in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-15-2010, 09:26 PM
  7. Copy Paste from Active cell
    By briank in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-06-2005, 07:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1