God knows why but excel for Mac 2016 does not have a "use relative references" button.
What I am trying to do is record a macro that deletes the single space in front of some text in a list of data, because I need to pick up data from this worksheet and the stupid space in front as it is ******* up vlookup references.
So for example, I have " Name" in an excel cell and I want to write a Macro that deletes the space and results in "Name" in a cell, and then run that macro on the whole column of data. But because Excel for Mac killed the relative references button, I cannot do this. Which is massively annoying.
I have no idea how to actually code in VBA so I am at a loss.
Any ideas?
What I am trying to do is record a macro that deletes the single space in front of some text in a list of data, because I need to pick up data from this worksheet and the stupid space in front as it is ******* up vlookup references.
So for example, I have " Name" in an excel cell and I want to write a Macro that deletes the space and results in "Name" in a cell, and then run that macro on the whole column of data. But because Excel for Mac killed the relative references button, I cannot do this. Which is massively annoying.
I have no idea how to actually code in VBA so I am at a loss.
Any ideas?
0 commentaires:
Enregistrer un commentaire