Hi.
How do I select 2 cells (i.e. Range("BA5:BA6").select) and have a code fill this down an excel sheet to the last row.
Here's what I have but it doesn't work:
Any help is appreciated![]()
Please Login or Register to view this content.
![]()
Hi.
How do I select 2 cells (i.e. Range("BA5:BA6").select) and have a code fill this down an excel sheet to the last row.
Here's what I have but it doesn't work:
Any help is appreciated![]()
Please Login or Register to view this content.
![]()
Maybe![]()
Please Login or Register to view this content.
Thanks,
Solus
Please remember the following:
1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.Highlight the code in your post and press the # button in the toolbar.2. Show appreciation to those who have helped you by clickingbelow their posts.
3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
"Slow is smooth, smooth is fast."
Thank you.
I changed "lrow" to LR.
The code filled down BA5 but not BA6.
How do I get these two cells filled down?
If you were to manually do it you would select both cells, click on the black dot on the bottom right hand corner and fill down.
When I record the action this is what I got:
However I need that instead of the end of the range being "BA314" I would like for it to detect the last-row instead.![]()
Please Login or Register to view this content.
![]()
Please Login or Register to view this content.
Thank you Solus, your answer worked![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks