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.
|