Hi,
I'm trying Autofill Current Column To Last Cell in Column B When i Click AutoFill button .
And Convert The Range After Autofill To Value .
File attachment .
Please Help
Thank You![]()
Hi,
I'm trying Autofill Current Column To Last Cell in Column B When i Click AutoFill button .
And Convert The Range After Autofill To Value .
File attachment .
Please Help
Thank You![]()
![]()
Please Login or Register to view this content.
Last edited by protonLeah; 12-24-2020 at 06:06 PM.
Ben Van Johnson
Thank you! I'm getting a Run-time error '1004': AutoFill method of range Class Failed. When I click on Debug, it highlights the following line:
![]()
Please Login or Register to view this content.
The File In Attach
When you Click AutoFill button , It Go To First Column Is Blank And Copy The Formula In Cell 1 Above The Current Column And Paste It In Cell 3 And AutoFill This Cell In Current Column Until Last Range Before Column . I don't want It .
I want , continue AutoFill to Last Row Have Data In Column B And Convert The Range After Autofill To Value.
Thank you so much
Last edited by Seif Elnasr; 12-25-2020 at 12:58 AM.
Hi Seif,
This is another approach to try ...
![]()
Please Login or Register to view this content.
If I was able to help, you can thank me by clicking the * Add Reputation under my user name
Hi nankw83,
Wow this is amazing
this is magic
Thank you very much protonLeah
Thank you very much nankw83
thank you very much all![]()
Last edited by Seif Elnasr; 12-25-2020 at 12:47 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks