nextcol

I use this to load pictures on a sheet. Right now it includes bringing in the file name and putting it below the pictures. I need to disable that part and cannot find the way unless I get an error. Could someone look at this and suggest a way to disable the file name part? Thanks Sub...

Hi all, I've composed this macro which does what I need; (finds last used column in row4 and drags the contents 1 column to the right). In this case, last used column= BA Sub newmonth_book() Sheets("Book").Select Range(Cells(4, 53), Cells(8, 53)).AutoFill Destination:=Range(Cells(4...

I have a worksheet where I want to autofill the fields in rows 4 to 8from the last populated column, into the next column. Rows 4 to 8 will always be ‘fixed’. Currently, the last populated column is BA. I can establish the LastCol & NextCol variables but I can’t passthem to my AutoFill command...

Hi, I have the following code which creates a table in a worksheet based on data copied from another worksheet. However it throws up a syntax error and everything I have tried isn't working. With Sheets("Data") x = .Cells(1, .Columns.Count).End(xlToLeft).Column On Error Resume...