How to take results of this code and place it in col 3 of a new table

**kelwood** · 10-03-2012, 12:57 PM

Greetings all,

I have a question regarding the process for taking the data of the code below and writing it in to three separate blocks in a new table in the same document using vba.
Thanks in advance to those who have an idea how to resolve this.

Please Login or Register  to view this content.

**macropod** · 10-03-2012, 01:31 PM

You say you want to write the data:

to three separate blocks in a new table in the same document

Where in the document?

**kelwood** · 10-03-2012, 01:34 PM

The table is on the 1st page (cover page) of the same document and serves as a summary of the remaining pages.

**macropod** · 10-03-2012, 02:20 PM

Does the table already exist?

**kelwood** · 10-03-2012, 03:27 PM

Yes it does.

**kelwood** · 10-03-2012, 03:50 PM

I realize that my initial cod econtains an error in line 7 and have corrected it.

It now reads:

Please Login or Register  to view this content.

**macropod** · 10-03-2012, 04:55 PM

Ah, yes, that's what I was wondering about!! Try adding something along the lines of the following after your existing 'End With':

Please Login or Register  to view this content.

This will populate A2, B2 & C2 in table 1.

How to take results of this code and place it in col 3 of a new table

LinkBack

Thread Tools

Rate This Thread

Display

How to take results of this code and place it in col 3 of a new table

Re: How to take results of this code and place it in col 3 of a new table

Re: How to take results of this code and place it in col 3 of a new table

Re: How to take results of this code and place it in col 3 of a new table

Re: How to take results of this code and place it in col 3 of a new table

Re: How to take results of this code and place it in col 3 of a new table

Re: How to take results of this code and place it in col 3 of a new table

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions