|
To copy Sheet 2 to Sheet 1 in Excel file using VB.net -- Vishal --
Hello there, I am using Visual Studio 2005 (VB.net) and am exporting data from VB.net to Excel. 1>I need to cut the entire contents of a sheet 2 to sheet 1 in VB.net 2>Also, the contents have to be copied below the contents of sheet 1 so I need to know where the contents of sheet 1 are ending. Hope you could help! -Vishal. |
|
-- Vishal --
Anybody..out there know this solution.? -V |
|
-- Pankaj --
Try to look into excel VBA help about Excel special Cell. VBA has a special constant that tells excel where the contents are ending on a sheet (same as pressing Ctrl+Enter) HTH Pankaj |