Exporting Last line of data

[iainIOW]

Hi! My first post on this board..!!

Im looking to create a procedure in Excel that looks at the last row of a list of data and exports to bookmarks in Word. IM sure i have done this before, but have not come across the problem of variable cells..
My spreadsheet has 6 Columns, and data is entered in the cells below. At the moment, the user has to write the data out again in a word document (as a letter).

Anyone got any ideas on how to do this? Im more of an access VBA man, but unfortunatly my users dont have access!!

 

[jindon]

hi

to get the bottom row used in the sheet

try

ActiveSheet.UsedRange.Row + ActiveSheet.UsedRange.Rows.Count - 1

jindon

 

[iainIOW]

comes back with "object does not support property or method" ive attached that code to the onclick property of a button on my sheet.

 

[jindon]

hi

sorry code had been edited

like to try again?

jindon

 

[iainIOW]

still comes back with the same, is this something to do with me using it with a button?

 

[iainIOW]

ttt

ive got all of the code to get the data over in to the right place in word.. i just cant get excel to work out that it needs to get data from the last row that has been used..

i.e i could code it to look like this: -

.Goto What:=wdGoToBookmark, Name:="Address2"
.TypeText Text:=Range("D2")

But obviously the range D2 wont always be the same, it will be Dn (where n is the last used row number)

Any ideas? appreciate your help.