Afzaal Ahmed
New Member
Members
Forum Posts: 1
Member Since:
November 23, 2023
November 23, 2023
Offline
Sub math()
Dim num As String
Range("c2:g21").ClearContents
a = Range("a2")
a2 = Range("a3")
Range("c1:g21").NumberFormat = "@"
b = Range("b2")
d = 1
For Count = 1 To b
c = a * a
Range("c" & d + 1).Value = WorksheetFunction.Rept(a, d)
Range("d" & d + 1).Value = "X"
Range("e" & d + 1).Value = WorksheetFunction.Rept(a2, d)
Range("f" & d + 1).Value = "="
num = WorksheetFunction.Product(Range("c" & d + 1).Value, Range("e" & d + 1).Value)
Range("g" & d + 1).Value = num
d = d + 1
Next Count
End Sub
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Fiona Tobin, Dom Brosnahan, Renel Leone, Brenda Wolf
Guest(s) 10
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1917
SunnyKow: 1432
Anders Sehlstedt: 900
Purfleet: 414
Frans Visser: 346
David_Ng: 306
Hans Hallebeek: 290
lea cohen: 246
Jessica Stewart: 219
A.Maurizio: 216
Newest Members:
Dennis Ringler
Deepak Kumar
Michal Kučera
Stephen Keating
David M Connelly
Quick Analytics
Peter Craven
Thomas Huybs
Cassandra McGuire
Leo Bonaparte
Forum Stats:
Groups: 3
Forums: 24
Topics: 6882
Posts: 30170
Member Stats:
Guest Posters: 49
Members: 33710
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —