C# programming - Getting number of last non-blank cell (column) in a row.

Posted to microsoft.public.excel.programming

Paddy[_2_] Paddy[_2_] is offline

external usenet poster

Posts: 2

C# programming - Getting number of last non-blank cell (column) in a row.

I need to get the column number of the last non-blank cell in a row. I
am using the Excel Com object in a .NET app to get this done

I have something like this
Range rg = xSheet.get_Range("A1","A1"); // xSheet is the worksheet
object.
int lastColumnNumber = rg.Cells.....

I am not sure what the method call to do or the steps to follow.
Any help is appreciated,
- K.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
row number of last non-blank cell	Bill Brehm	Excel Worksheet Functions	12	January 16th 10 04:31 PM
macro that will paste a number in first blank cell of a column	asebes	Excel Discussion (Misc queries)	1	December 28th 09 05:34 PM
SUM values in this column F only if cell is blank in column Q...HE	Lisa	Excel Discussion (Misc queries)	3	March 1st 07 03:22 PM
how to calculate the number of non blank cells from any column?	Mahesh	Excel Worksheet Functions	2	August 8th 06 01:14 PM
Number of different items in an entire column without knowing if some of the cells are blank	[email protected]	Excel Programming	10	March 20th 05 05:31 PM

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

Menu

About Us