adamprocter
Board Regular
- Joined
- Apr 13, 2015
- Messages
- 53
This is workgin great and getting the info from g4 and pasting into word bookmark but
What I want to do is get the last row in G so that as new data is saved I can paste it into word. But all my attempts seem to fail, its just puts in value of last row (4) not the value from the field itself ?
Neither of these work.
Code:
Set wdRng = wdDoc.Bookmarks("ClientName").Range
wdRng.Text = Range("G4").ValueWhat I want to do is get the last row in G so that as new data is saved I can paste it into word. But all my attempts seem to fail, its just puts in value of last row (4) not the value from the field itself ?
Neither of these work.
Code:
wdRng.Text = Range("E" & Rows.Count).End(xlUp).Row
wdRng.Text = Range("E65536").End(xlUp).Row
Last edited:
