Thread: [Solved] Issue With VBA
View Single Post
 
Old 02-02-2023, 06:08 AM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2019
Expert
  
Join Date: Apr 2014
Posts: 871
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default
try changing to:
Code:
  .Range("T15").Formula = "=Current!E" & Worksheets("Current").Cells(Rows.Count, "E").End(xlUp).Row
Reply With Quote