Working code need inputbox for range

**abjac** · 02-10-2013, 03:54 AM

Hi I am really not good to put input boxes into code. I need one for this one below
A good working Patel45 code. Need a inputbox so i can set range and choose the column.

Please havea a look
Sincerely
Abjac

Please Login or Register  to view this content.

**Excel4Everything** · 02-10-2013, 05:42 AM

Hi!

I recorded a simple example video about how to use InputBox: http://excel4everything.blogspot.fi/...-inputbox.html

Hope this helps.

**HaHoBe** · 02-10-2013, 06:23 AM

Hi, abjac,

A good working Patel45 code.

Either you missed to ask for the addition in time or it wasn´t delivered.

Regarding the area:

Please Login or Register  to view this content.

Regarding the column:

Please Login or Register  to view this content.

The range could be narrowed down by using SpecialCells if other data or empty cells are included.

HTH,
Holger

**abjac** · 02-10-2013, 06:52 AM

HI Excel 4 i tried with your tutorial and thanks allot, but i dont know why have problems with the input boxes, but i need to practise this more. SO i hope this can be a help thanks

Holger. Thanks allot. No i didnt ask at that time, because i was not sure if i needed input boxes. But i tried your codes and its working really perfect.
So its really nice. Need them tomorrow for some work, where i have to use it after to paste the result in another application.
Thanks to both of you
Have a nice day
Sincerely

Abjac