Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,476 questions
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
I'm trying to create a script in Excel by recording. Everything works great except when I run it, the cell I dragged down to copy a formula down gives the result of the value from the first cell and not the formulas result. I've ensured automatic fill is on. For example, I have a list of email addresses and I want this part of the script to "xxxx" the beginning of each. When I record, the result is xxxgfds@gmail.com, the cell under is xxxjutes@gmail.com and that is correct. However, when I run the script I get xxxgfds@gmail.com in both cells, or in my case a few hundred. Any ideas?