Can anyone help with this please?
I’m trying to set up an auto execute macro in a number of spreadsheets
that will automatically record the ID of any user who opens and saves
the file. I have set this up Ok but can only it it to work for files
where I name the file name in the code ie
Applicatio
Ashish,
Thanks for your help, that works just fine.
If I was to take that a step further, how would I amend the code so
that the copy range stepped 200 to the right, regardless of how many
rows I highlighted ie sometimes I'll copy one row, somestimes it may
be 2,3..4 rows.
I can do it one at a t
Hello Group,
Can anyone help me with this “simple” line of code. I need a line
that will allow me to:
Starting at the cell I’m in,
Extend right for 200 cells
Activate the cells & copy
I want to use easy code ie along the lines of
ActiveCell.Offset(0,200).Range.Select
Or
Range.ActiveCell.Offset
First attempt at this, so hopefully this is how it works
I have a spreadsheet with about 25 tabs and about 200 columns with
lots of different widths. As its updated by many the widths get moved
about. Before it is released, I run a macro to go through each column
in each tab and restore it to it
