hi guys, so I have 3 Columns, A, B and C. so when I click the multiply button the vba will multiply column A with B and the result will be in Column C. I have 40000 rows so instead of define range like .range(1:40000), can I just like autofil range without need to define the range manually? so when the rows get added macro will automatically multiply the vcolumns?
Bookmarks