Thread: macro is to update column 13 and 14 of worksheet "Voice BB Pending"as per column 2 and 3 of "Activity log" .
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Scossa Scossa is offline
external usenet poster
  
Posts: 26
Default macro is to update column 13 and 14 of worksheet "Voice BBPending" as per column 2 and 3 of "Activity log" .
On 19 Ago, 08:54, San wrote:

cut

* For lngLoopS = 2 To lngLastS

How lngLastS is decalred?
Is set in Caller()
lngLastS = shtSource.Cells(shtSource.Rows.Count, 1).End(xlUp).Row

but is used in nehaAll()

Bye!
Scossa
Reply With QuoteReply With Quote