Hello!
Probably a noob question, but I am a noob, and i cant find the answer anywhere.
when I use this code:
Dim Startcell As Variant
Set Startcell = Cells(ActiveCell.Column)
I cant get "Startcell" to take the value from ActiveCell.Column. I can see that ActiveCell.Column has a value, but its not transfered to "Startcell"
If i change it to:
Dim Startcell As Variant
Set Startcell = ActiveCell.Column
I get an error saying that object is missing.
What am I doing wrong?
Appreciate any help!
It would be easier to help and test possible solutions if you could attach a copy of your file. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary). See the yellow banner at the top of this page for instructions to attach a file.
You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
Practice makes perfect. I'm very far from perfect so I'm still practising.
I agree with the above but do you just want startcell to be the column number of the active cell?
Please Login or Register to view this content.
Okay, i will Attach a copy when i have the possibility.
you are correct, I want Startcell to be the column number of the active cell
Last edited by AliGW; 07-27-2021 at 08:52 AM. Reason: PLEASE don't quote unnecessarily!
Try:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks