close

Hey all,

I need your help to complete a project of mine. I am making project
using Macros. I have least knowledge of VB Script. I am creating macros
by recording it. I have created subtotals for a worksheet. Now, I need
to copy only the titles and the numbers assigned to it. But when I copy
it and paste it, or even using paste special, Values, I get the complete
content but not the only required data. Ex. I select option 2 when
created subtotals. There, I get a list of all the variables with a
mark next to it. If I copy the content and paste it else where, I get
all the details which appear when is clicked. I need only the data in
there, i.e, only contents to be copied and pasted. Please help. Quick
response is appreciated.
Thanks,
Pravi--
praveen_khm
------------------------------------------------------------------------
praveen_khm's Profile: www.excelforum.com/member.php...oamp;userid=30364
View this thread: www.excelforum.com/showthread...hreadid=500182You have replies at one of your other posts.

praveen_khm wrote:
gt;
gt; Hey all,
gt;
gt; I need your help to complete a project of mine. I am making project
gt; using Macros. I have least knowledge of VB Script. I am creating macros
gt; by recording it. I have created subtotals for a worksheet. Now, I need
gt; to copy only the titles and the numbers assigned to it. But when I copy
gt; it and paste it, or even using paste special, Values, I get the complete
gt; content but not the only required data. Ex. I select option 2 when
gt; created subtotals. There, I get a list of all the variables with a
gt; mark next to it. If I copy the content and paste it else where, I get
gt; all the details which appear when is clicked. I need only the data in
gt; there, i.e, only contents to be copied and pasted. Please help. Quick
gt; response is appreciated.
gt; Thanks,
gt; Pravi
gt;
gt; --
gt; praveen_khm
gt; ------------------------------------------------------------------------
gt; praveen_khm's Profile: www.excelforum.com/member.php...oamp;userid=30364
gt; View this thread: www.excelforum.com/showthread...hreadid=500182

--

Dave Peterson

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()