Forum Discussion
VBA help
I am a beginner at excel and VBA and I have an issue that's out of my skill set. I need to create an algorithm that allows for specific columns to have their length increased by x13 via duplicating a...
The easiest way to get into VBA is to 1) Install the Developer ribbon (in File/Options) 2) Press "Record Macro" 3) do the thing yourself in Excel that you want the macro to do 4) Press "Stop recording" 5) Look at the VBA code Excel generated from your actions. Learn from it. Optimise/improve by hand from there.
- I will look into that, yet the sheets that I am working on have columns that go down to 65000 and their are multiple columns and files I need to fix.
