View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Les Stout[_2_] Les Stout[_2_] is offline
external usenet poster
 
Posts: 396
Default Select rows to format

Hi could somebody please give me the correct code for the following.

LastRow = Cells(Application.Rows.Count, 1).End(xlUp).Row
Rows(LastRow + 2).NumberFormat = "0.00"

I need to format from LastRow + 2 more rows with "0.00"
What i have got formats the second row after the last row ?


thanks in advance

Les Stout

*** Sent via Developersdex http://www.developersdex.com ***