ExcelBanter - View Single Post - Copy Formula to Last Needed Cell in Spreadsheet

Thread: Copy Formula to Last Needed Cell in Spreadsheet

View Single Post

#1

Report Post

Posted to microsoft.public.excel.programming

Michael Smith Michael Smith is offline

Michael Smith is offline

external usenet poster

Posts: 77

Default

Copy Formula to Last Needed Cell in Spreadsheet

Try this...

Range("G2").Copy
Range(Selection, Selection.End(xlDown)).Select
ActiveSheet.Paste

*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!

Reply With Quote

Reply With Quote