About Us

[email protected]

All working thanks!!!!
wrote:
I am getting the message invalid or unqualified reference for the .rows
in the following line.

LastRow = .Cells(.Rows.Count, "B").End(xlUp).Row

Any ideas?

Thanks
Dave Peterson wrote:
I'd insert a new COLUMN A.

Dave Peterson wrote:

I'd insert a new row A.

Then pick out a column that always has data:

Option Explicit
Sub testme02()
Dim wks As Worksheet
Dim LastRow As Long
Set wks = ActiveSheet
With wks
.Range("a1").EntireColumn.Insert
LastRow = .Cells(.Rows.Count, "B").End(xlUp).Row
With .Range("a1:A" & LastRow)
.Formula = "=row()"
.Value = .Value
End With
End With
End Sub

wrote:

Hi,

I need to insert row numbers to a csv file that is generated from a
spreadsheet of data. Thought I could user NumberRows() but not sure if
this is correct.

Could someone tell me the best way to insert row numbers for each row
of data. The amount of data varies each time the csv file is generated.

Thanks
Steve

--

Dave Peterson

--

Dave Peterson

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Insert Row numbers	Gene Augustin	Excel Discussion (Misc queries)	3	February 24th 09 08:20 AM
how do I insert Item numbers	EJ Jacques	Excel Discussion (Misc queries)	1	May 24th 08 12:30 AM
how to insert page numbers	Mylo	Excel Discussion (Misc queries)	1	August 5th 05 11:19 AM
how do I insert an ' in front of many rows of numbers?	jszuch	Excel Programming	2	April 25th 05 02:52 PM
Macro to insert numbers	Richard[_15_]	Excel Programming	6	August 1st 03 07:06 AM

Menu

About Us