ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Jump to new line after the first record is displayed (https://www.excelbanter.com/excel-programming/315965-re-jump-new-line-after-first-record-displayed.html)

mangesh_yadav[_164_]

Jump to new line after the first record is displayed
 

I have solved half the problem by using Cells(i, 2) in:
Destination:=Cells(j+1, 1))
instead of
Destination:=Range("A1"))

There is a new row inserted, but it still starts from the last colum
of the previous row.


- Manges

--
mangesh_yada
-----------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...fo&userid=1047
View this thread: http://www.excelforum.com/showthread.php?threadid=27584


mangesh_yadav[_165_]

Jump to new line after the first record is displayed
 

So the solution...???

manges

--
mangesh_yada
-----------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...fo&userid=1047
View this thread: http://www.excelforum.com/showthread.php?threadid=27584



All times are GMT +1. The time now is 05:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com