Hello, everyone,
i have a little neat code that copies the values in one column down until the next one is worth.
Unfortunately the code only works if you define the column in the code.
Can someone adapt the code to take the column of the activated cell.
So 'Activecell'.
Here's the code:
Please Login or Register to view this content.
Thank you very much.
Untested, but it would probably be something like:
Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Thanks for the answer
Creates a
#BEZUG
Error in the empty cells.
What's #BEZUG?
Post a sample workbook.
How aboutIf the cell in row1 is blank, every blank cell is filled with #REF.Please Login or Register to view this content.
Re: VBA to copy a value until new value in Active column
Originally Posted by TMS
Bet for a german version …
I guessed that may be the case, but I still don't know what the error is in EnglishBet for a german version …
It's #REF!, possibly because row 1 in the column was blank.
Variations on a theme. The second two cater for row 1 being blank.
Please Login or Register to view this content.
Interesting that the OP is using a German version of Excel though the location is London. ConfusingBet for a german version …
Re: VBA to copy a value until new value in Active column
Not as it's a well known financial place, like here in Paris where I have seen English version like Spanish and other local ones …
Thank you very much y'all.
It was a very great help.
And yes it is a german version.
Got a PC Tablet from a friend and am too lazy to install new office.
Again guys thanks for the great help.
You're welcome.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Or you can use this way:
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks