View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
houghi houghi is offline
external usenet poster
 
Posts: 56
Default Pivot and VB scripting range problem

I have added the following
lastrow = Cells(Rows.Count, 1).End(xlUp).Row
MsgBox lastrow

That shows 37. To be sure I even did ` lastrow = "37" ` so there won't
be an issue with calculation lastrow.

Roger Govier wrote:
Hi

What value shows for lastrow?



houghi
--
Knock-knock.
Who's there?
Under the Patriot Act, we don't have to tell you that.