Enquiry on VB Syntax

dhuto777 via VBMonster.co · Joined: 04 Oct 2007 Posts: 3

Dearest All,
I am new to VBA. So please be patient with me.
I am learning how to write macros. However i am stuck in this area:
Given a set of data (Eg,By Group, By GDP) in Sheet1, I wish to copy 1 group
(Eg.Singapore) and GDP figures into a new worksheet named after Singapore.
What must I do?
Thank you
Lee Coh

--
Message posted via VBMonster.com
http://www.vbmonster.com/Uwe/Forums.aspx/vb-syntax/200607/1

Archived from group: microsoft>public>vb>syntax

Bob Butler · Joined: 04 Oct 2007 Posts: 1325

"dhuto777 via VBMonster.com" wrote in message@uwe
> Dearest All,
> I am new to VBA. So please be patient with me.
> I am learning how to write macros. However i am stuck in this area:
> Given a set of data (Eg,By Group, By GDP) in Sheet1, I wish to copy 1
> group (Eg.Singapore) and GDP figures into a new worksheet named after
> Singapore. What must I do?

There are several ways depending on how the data is formatted. Since it
sounds like Excel the first thing I'd do is start the macro recorder and do
what you want to do manually and then look at the code it generated. It's
usually not the best but does get you started.

You should also find a newsgroup dedicated to VBA in Excel since VBA and VB
are not quite the same thing.

--
Reply to the group so all can participate
VB.Net: "Fool me once..."

dhuto777 via VBMonster.co · Joined: 04 Oct 2007 Posts: 3

Bob Butler wrote:
>> Dearest All,
>> I am new to VBA. So please be patient with me.
>> I am learning how to write macros. However i am stuck in this area:
>> Given a set of data (Eg,By Group, By GDP) in Sheet1, I wish to copy 1
>> group (Eg.Singapore) and GDP figures into a new worksheet named after
>> Singapore. What must I do?
>
>There are several ways depending on how the data is formatted. Since it
>sounds like Excel the first thing I'd do is start the macro recorder and do
>what you want to do manually and then look at the code it generated. It's
>usually not the best but does get you started.
>
>You should also find a newsgroup dedicated to VBA in Excel since VBA and VB
>are not quite the same thing.
>

Thank you
Lee Coh

--
Message posted via VBMonster.com
http://www.vbmonster.com/Uwe/Forums.aspx/vb-syntax/200607/1

dhuto777 via VBMonster.co · Joined: 04 Oct 2007 Posts: 3

Bob Butler wrote:
>> Dearest All,
>> I am new to VBA. So please be patient with me.
>> I am learning how to write macros. However i am stuck in this area:
>> Given a set of data (Eg,By Group, By GDP) in Sheet1, I wish to copy 1
>> group (Eg.Singapore) and GDP figures into a new worksheet named after
>> Singapore. What must I do?
>
>There are several ways depending on how the data is formatted. Since it
>sounds like Excel the first thing I'd do is start the macro recorder and do
>what you want to do manually and then look at the code it generated. It's
>usually not the best but does get you started.
>
>You should also find a newsgroup dedicated to VBA in Excel since VBA and VB
>are not quite the same thing.
>

Thank you
Lee Coh

--
Message posted via http://www.vbmonster.com

chr()-syntax Hi, I need to send a specific command to a POS-printer (for opening a cash drawer). The syntax to use, according to the printer's manual is: Decimal 27 112 0 200 200, where the last two can be omitted. And that is exactly what I am doing, so I

Syntax Help I'm a "newbie" at VB. Can someone please explain to me what's going on with this VB code??? SPTQueryName = If SPTQueryName) = True Then SPTQueryName

VB syntax for this...? Hi. Any idea how I 'un-NET' this to VB (and without using FSO!): Dim buf() As Byte Dim ret As Boolean Dim size As Integer size = 7000 Dim fnum As Integer Dim foo As Object ret = size) ReDim buf(size)

syntax to run a .exe I'm new to VB and am writing a small program in VB6 to copy a copy a few files and to run a .exe that installs snap shot viewer. My question is what is the vb command to run the .exe Thanks

Help with VB syntax... I have a VB script that is used to shutdown services in a certain order and reboot the servers and start the services in a certain order; this runs from server B. What I am trying to do is execute a batch file that reside on server A but from server B vb