Excel Macro Help.....

[alihussain19]

I have this to insert Data from word to the first empty row in excel bu
somehow it replaces the first row and that's where it only insert
data...
Any Help?:rolleyes

 

[Bob Phillips]

Do you want to get the first empty row? For column A, that can be got with

Cells(Rows.Count,"A").End(xlUp).Row+1

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Frank Kabel]

Hi
how are you currently inserting the data?. Do you use a macro. If yes
you may post your code

 

[kkknie]

Post some code so I know what you are up to...

Just a guess, but the row that should be pasted is probably determine
by this statement:

iRow = Range("A65536").End(xlUp).Row