Excel - Copy/paste pastes result not formula?

(0) Share

Report

Posted on by garthh

138

How do I paste a formula to selected cells in the same row?

The flow works but the formula result is pasted not the formula

See atachment

Categories:

Power Automate Desktop

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Agnius Bartninkas Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Have you tried using Copy from Excel worksheet and then Paste into Excel worksheet? This should generally do the trick.

-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.

Was this reply helpful? Yes No
garthh 138 on at

Like
a
(0)

Report
Copy link

Link copied!

Agnius, thank you
The result didn't change!
In Paste an option 'Named cells' exists however I don't know if that may work as I can't see where to name the cells selected?
Thoughts?

Was this reply helpful? Yes No
garthh 138 on at

Like
a
(0)

Report
Copy link

Link copied!

Agnius, I looked at the flow again and found Paste had not been saved
This is the result but how do I Paste to all selected cells?

Was this reply helpful? Yes No
kinuasa 799 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
I would suggest that send following keys after selecting the cells.
{Alt}({E})SF{Return}

Was this reply helpful? Yes No
garthh 138 on at

Like
a
(0)

Report
Copy link

Link copied!

Kinuasa, thank you
i just found sending ‘Enter’ after Ctrl+V via the send keys Action works. I’ll try your suggestion later

Was this reply helpful? Yes No