I have a column about 900 cells long (from a web page table import each day that changes) I want to copy to another column and make all the cells absolute so I can position the copied cells however I want and they retain the original data. I know about the "=sum($A$1)" technique and the "F4" short cuts, but they are only good for working with individual (or small number of) cells. If I copy/paste a column of 900 cells, how can I easily make the complete column Absolute?
Select the column and run this small macro:
Please Login or Register to view this content.
Gary's Student
Hi and welcome to the forum
Is that what your formulas look like...=sum($A$1) ??
If so, 2 things...
1. you dont need the =sum part, just use =$A$1
2. if your formula is =A1, then you can use find/replace...find A replace with $A$
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
The find & replace (cntrl h) worked great! Thanks!
I've marked this thread as SOLVED for you.
Next time, select Thread Tools from the links above and mark this thread as SOLVED. Thanks.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks