+ Reply to Thread
Results 1 to 4 of 4

लेंथ formula ko copy paste kane ke liye set kar sakte hai

  1. #1
    Forum Contributor
    Join Date
    09-14-2012
    Location
    mumbai,india
    MS-Off Ver
    Excel 2003
    Posts
    355

    लेंथ formula ko copy paste kane ke liye set kar sakte hai

    क्या एक्सेल मे length फॉर्मूला को copy paste करने के लिए सेट कर सकते है। क्योंकि मुझे हर बार length फॉर्मूला मे आखरी row को edit करके सेट करने पड़ रहा है।
    यानि के मैं चाहता हूँ की लेंथ फॉर्मूला को हर worksheet मे सिर्फ कॉपी paste करने से लेंथ मिल जाए बिना एडिटिंग के।
    Attached Files Attached Files
    Last edited by sanju2323; 03-13-2016 at 06:08 AM.

  2. #2
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365 ProPlus
    Posts
    9,447

    Re: लेंथ formula ko copy paste kane ke liye set kar sakte hai

    One way is to use the VBA to insert the formula in the cells.
    To use this, select the cell where you want to insert the formula e.g. cell F2 on Sheet1 and press Ctrl + Shift + F to insert the formula in F2 and F3.

    Refer to the attached for details.

    This is a macro-enabled workbook, so you will need to enable macros while prompted after opening the file.
    Attached Files Attached Files
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

  3. #3
    Forum Contributor
    Join Date
    09-14-2012
    Location
    mumbai,india
    MS-Off Ver
    Excel 2003
    Posts
    355

    Re: लेंथ formula ko copy paste kane ke liye set kar sakte hai

    sktneer,
    Thank you so much.

  4. #4
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365 ProPlus
    Posts
    9,447

    Re: लेंथ formula ko copy paste kane ke liye set kar sakte hai

    You're welcome Sanju! Glad I could help.
    Thanks for the feedback.

+ 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: 3
    Last Post: 12-02-2015, 11:31 PM
  2. [SOLVED] হিসাব তৈরীকরন।
    By bablubg in forum Non English Excel
    Replies: 9
    Last Post: 04-16-2014, 02:06 AM
  3. Get data from sybase central/sql anywhere 11.01.2352 to excel 2003 with vba
    By vbvince in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-14-2012, 05:24 AM

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