Diane Lonergan
asked on
Filldown VBA
Could someone help with vba to copy a formula from cell c2 through to cell c72194. Obviously cant do it with a drag and keep having problems with using shortcuts too.
Many Thanks
Many Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Some time it can be easier to fill up instead of down.
- Write your formula in the lowest cell to where you want your formulas (C72194).
- Press Ctrl+C
- Move cursor one cell up.
- Press Ctrl+Shift and UpArrow
- If neseccary, release Ctrl and adjust the top of the range as you whish.
- You may need to press F9 to recalculate the worksheet.
This comment is not qualified as an answer, as it is not what you asked for, but maybe it can help in the future.
- Write your formula in the lowest cell to where you want your formulas (C72194).
- Press Ctrl+C
- Move cursor one cell up.
- Press Ctrl+Shift and UpArrow
- If neseccary, release Ctrl and adjust the top of the range as you whish.
- You may need to press F9 to recalculate the worksheet.
This comment is not qualified as an answer, as it is not what you asked for, but maybe it can help in the future.
Is there data in either column B or column D? If so, you can double-click the lower right corner of the cell you want to fill down.
ASKER
Thanks everyone for your assistance. I appreciate it.
ASKER
Sorry Subodh, I thought I had marked you as the best solution. I scrolled to the wrong entry.
Hi Diane!
You haven't accepted any answer yet. :)
So all you need is to select the answer which worked for you.
You haven't accepted any answer yet. :)
So all you need is to select the answer which worked for you.
ASKER
Thanks Everyone for your help.
You're welcome Diane!
Open in new window