Search results for query: *

Thanks guys, everything works now.

Within the 'With' Statement I was able to distinguish the columns from one another... I was trying to get one column to copy at a time within the with statement, but I was only getting the first row of each column. Skip, can you show me how a horizontal sort works?

This is an experiment I created for myself so that I could figure out a method of passing data by selection, instead of coding the fixed location of the data source. Copy the code I wrote and then fill a 5x5 set of cells with numbers. Then highlight the values and activate the macro. I was...

This is Macro is for selecting sorting and pasting values. I was able to get the values from any column of the selection area to populate other cells, but I cant populate the correct number of cells without giving the exact range of the destination. Among other things, I tried to use offset...

Skip, you have the knowledge! Here:http://www.tek-tips.com/viewthread.cfm?qid=202361 So, I want: 1. part of program that selects data 2. part of program that makes new sheet 3. part of program that sets up new sheet 3. part of program that updates new sheet 4. part of program that saves new...

Ok. So everything was quite confusing before I put this into practice. Im interested in having a dynamic selection process that the user can select a contiguous set of cells and the program will deal with routing the right values to the right columns. I think that must be possible... To...

Correct. Within the selection area, item will be mapped to item, style to style, description to description, color to color, size to size, and quantity to quantity. Also highlighted will be the 'to' and 'from' values, of which we only need the first value of each to name the file. This is...

I have learned a bit about vb recently and have been using it for my job, I still have questions and dont know how to do many things yet. I appreciate your time and efforts and hopefully I can figure out how to make this procedure work. This is all taking place in vb6 and excel 2003. I am...

This is really interesting, I am new to vba and I want to be able to adapt this save as dialog to a form that I have made. I need this to function When the user clicks browse on the form.