LinkBack URL
About LinkBacks
Hi,
I'm not quite clear what you're asking. If all you want to do is have vba enter a formula for you then
If you want your range to be the result of B4 * B3 then
Range("your_range") = "=B4*B3"
RegardsRange("Your_range") = Range("A4") * Range("B3")
Hi,
I'm not quite clear what you're asking. If all you want to do is have vba enter a formula for you then
If you want your range to be the result of B4 * B3 thenRange("your_range") = "=B4*B3"
RegardsRange("Your_range") = Range("A4") * Range("B3")
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
found error in code but still does not work
actual code:
Sub insertformula() Range("b4") = Range("b4") * Range("B3") End Sub
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks