First empty row (Visual MFC)

F

fiufiu

Hello,
I have macro in vba and i need it in Visual C++
Does anyone know how to do it?
I would be very grateful for any help

firstEmptyRow =
ActiveSheet.UsedRange.Cells(ActiveSheet.UsedRange.Cells.Count).Offset(1,
0).Row
Set firstEmptyCell = Range("A" & firstEmptyRow)
firstEmptyCell.Select

I need finally something like that:

Range ExcelRange;
_Worksheet ExcelSheet;

ExcelRange = ExcelSheet.GetRange(firstemptyrow/*COleVariant("Axx")*/,vOpt);
,where xx is number of first empty row

Thanks for any help
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

first empty row (visual c++) 0
Excel Programming: SetItem and SetValue Does Not Work 0
SetItem and SetValue Does Not Work 0
MFC - CopyFromRecordset - Copy data to Excel 0
Excel automation from C++ with MFC 1
Populate First Empty Cell In each Row with Text Values 0
Button to copy row to first empty row on another sheet 16
Find first empty row of a table? 3

Top