Excel Macro Help.....

A

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
 
B

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)
 
F

Frank Kabel

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

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
 
Top