For Loop

**SkyGod** · 09-18-2021, 10:26 AM

Hello,
I have a SQL table in sheet1

I wanna calculate from S7 to lastrow cells as result of M7 * T7 with the macro.
like, M8*T8 into S8
M9*T9 into S9, untill the last row of the S column.
I wanna do that with Application.WorksheetFunction.
Not with Range("").Formula method.
How can i do that?

Thank you for help!

**davesexcel** · 09-18-2021, 10:34 AM

Please read the yellow banner at the top of this page on how to attach a sample workbook.

**karmapala** · 09-18-2021, 10:36 AM

Please Login or Register  to view this content.

For Loop

LinkBack

Thread Tools

Rate This Thread

Display

For Loop

Re: For Loop

Re: For Loop

Thread Information

Users Browsing this Thread

Similar Threads

Loop through emails to find Email today, if not found loop Date -1

[SOLVED] VBA to loop through cell-defined range and paste table output after each loop.

Loop through a data validations list and for each loop count the number of occurences

[SOLVED] (Beginner help) For loop inside do loop that displays information from reference sheet.

[SOLVED] Auto email loop with formatted table data breaking on second loop VBA

[SOLVED] VBA to loop within a loop of multiple blocks of data (currentregion) ... Expert needed

[SOLVED] Copy dynamically changing column and Paste using VBA Loop (Loop within Loop)

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions