modify range macro

**var** · 12-20-2011, 10:10 PM

Hi , Can any one help with a macro script..

I created a range "range1" using allow user to modify range. Iam looking for a macro which edits the range1 as pre-selected.

Means, after selecting cells, when I run a macro, "range1" must be modified to selected range.

Would be a great help if some helps me with this..

thanks
var

**pike** · 12-21-2011, 05:36 AM

hi var

what the code?

maybe use an inputbox....

Please Login or Register  to view this content.

**var** · 12-21-2011, 01:00 PM

Hi Pike, thanks heaps.. Unfortunately i don't know much about codes..can you help me with full code please..

thanks again..
var

**pike** · 12-21-2011, 02:27 PM

In var what do you have so far that needs the code?

**var** · 12-22-2011, 11:01 AM

hi Pike I do NOT have any code..I want a code to be created..

Plz see the image..

range1 macro.jpg

**pike** · 12-22-2011, 04:17 PM

Welcome to the forum

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!