Hi Experts,
Right now am using a code to copy a batch of file from a folder & pasting
them in new folder but the issue is, i have to put all the file names in a
column & right now i have files in a different columns.
So please check the attached files & the code & please modify it for
selecting th
What I would do is:After using the FileDialog functions to select the
source/destination folders,I would loop through the entire range from B2 to
M5000 and look for non-blank cells.then, if the cell contains the name of a
file that exists, copy the file.Like:
Dim rng As Range
Dim dRange
That is what I'm saying (I think).Attached you will see changes I made to your
macro.You can either set the range = M2:M5000Set dRange = Range("B2:M5000")
or you can select a specific range and only process the cells selected:
Set dRange = Selection
If the macro stops when it encounters a #N/A o
Paul,
I mean to say, that right now the code which am using to perform this
event. I have to put all the files in a column like below.
a850kaa271-m-1-3x.jpg
a850kaa272_m_1_3x.jpg
aip4kaa271_m_1_3x.jpg
aip5ckaa271_m_1_3x.jpg
and i want to perform this event with the data like below & i am getin
