Click here to Skip to main content
15,907,910 members
Home / Discussions / C#
   

C#

 
GeneralRe: Finding the first empty row in an Excel sheet /*Edited*/ Pin
Stefan Troschuetz7-Feb-05 22:14
Stefan Troschuetz7-Feb-05 22:14 
Don't know if this will help you, but I'll give it a try. In my VBA makros I use the following code and it works great.
ActiveSheet.Cells(ActiveSheet.Rows.Count, 1).End(xlUp).Row

/* Edit
The above code returns the last non-empty row, so you'll have to increase the result by one
*/






www.troschuetz.de
GeneralBacking up files with Alternate Data Streams Pin
gxdata7-Feb-05 15:52
gxdata7-Feb-05 15:52 
GeneralUsing an .MDB database file Pin
SignMan3597-Feb-05 15:07
SignMan3597-Feb-05 15:07 
GeneralRe: Using an .MDB database file Pin
Luis Alonso Ramos7-Feb-05 19:27
Luis Alonso Ramos7-Feb-05 19:27 
GeneralLinked list some sort of help Pin
mik5557-Feb-05 13:37
mik5557-Feb-05 13:37 
GeneralRe: Linked list some sort of help Pin
rchokler7-Feb-05 21:15
rchokler7-Feb-05 21:15 
GeneralRe: Linked list some sort of help Pin
leppie7-Feb-05 21:37
leppie7-Feb-05 21:37 
GeneralDataGrid Question Pin
jll03307-Feb-05 13:25
jll03307-Feb-05 13:25 
GeneralDesigning Problem Pin
rchokler7-Feb-05 13:15
rchokler7-Feb-05 13:15 
QuestionWhy can't the as operator perform user-defined conversions? Pin
Patric_J7-Feb-05 12:17
Patric_J7-Feb-05 12:17 
AnswerRe: Why can't the as operator perform user-defined conversions? Pin
leppie7-Feb-05 20:56
leppie7-Feb-05 20:56 
GeneralDataGrid Question Pin
jll03307-Feb-05 11:53
jll03307-Feb-05 11:53 
GeneralCapture STDIO from DLL Pin
Larsenal7-Feb-05 11:17
Larsenal7-Feb-05 11:17 
GeneralRe: Capture STDIO from DLL Pin
leppie7-Feb-05 21:53
leppie7-Feb-05 21:53 
GeneralRe: Capture STDIO from DLL Pin
Larsenal7-Feb-05 22:01
Larsenal7-Feb-05 22:01 
GeneralRe: Capture STDIO from DLL Pin
leppie7-Feb-05 22:25
leppie7-Feb-05 22:25 
GeneralRe: Capture STDIO from DLL Pin
Anonymous8-Feb-05 6:16
Anonymous8-Feb-05 6:16 
GeneralRe: Capture STDIO from DLL Pin
leppie8-Feb-05 6:37
leppie8-Feb-05 6:37 
GeneralRe: Capture STDIO from DLL Pin
Larsenal8-Feb-05 10:17
Larsenal8-Feb-05 10:17 
GeneralGetting system icons Pin
Luis Alonso Ramos7-Feb-05 7:40
Luis Alonso Ramos7-Feb-05 7:40 
GeneralRe: Getting system icons Pin
Heath Stewart7-Feb-05 9:33
protectorHeath Stewart7-Feb-05 9:33 
GeneralRe: Getting system icons Pin
Luis Alonso Ramos7-Feb-05 10:18
Luis Alonso Ramos7-Feb-05 10:18 
GeneralRe: Getting system icons Pin
Heath Stewart7-Feb-05 10:28
protectorHeath Stewart7-Feb-05 10:28 
GeneralNotify Message Problem Pin
joy_priyank7-Feb-05 1:27
joy_priyank7-Feb-05 1:27 
GeneralRe: Notify Message Problem Pin
leppie7-Feb-05 2:20
leppie7-Feb-05 2:20 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.