Excel Interface

[HaydenMB]

Hi,

I have a database that exports a recordset into a spreadsheet and I need to lock the cells that I have copied the recordset into.

I can lock the cells but I don't know how I select the range of the copied recordset to lock the cells. The number of records that is pasted into the spreadsheet varies so I can't lock a specific range, but the recordset is always copied into the same cell.

Does anybody know how I can get round this problem?Your help would be greatly appreciated.


Hayden

 

[ormsk]

Could you not use RecordCount and pass the value to Excel so you can evaluate the range?

HTH

 

[ggriffit]

If you can't get the recordcount you could use the XL Special Cells option which will give you the last cell with data in or you could move through your primary key column until you find a row with no data.