"Vasant Nanavati" wrote... >You need something like the following awkward construction: > >Sub ForceRangeInput() > Dim vResp As Variant > Do Until...

Take alook...

Wes Copy the code and post it here(do not attach file). Someone will be able to ferret out the problem. Gord Dibben Excel MVP - XL97 SR2 & XL2002 On Tue,...

Thanks Matthew, I didn¹t realise that I needed the ³RefersToRange² part for it ot work. Cheers, Bp.) in article , Matthew...

I'd like to create a function that will automatically store a new high value of another cell when it occurs, but will not change if that first cell's value...

Hi, Can a macro be set to the default excel template so that when ever a user opens a new spreadsheet the macro is executed? where can the default excel...

I have 3 sets of 10 text boxes in a userform. I'd like to loop through each set filling them with info from 3 different columns on the worksheet using a for...

Hi I write a Macro in VBA IDE module 1 as: sub Selection() xxxxxxx end sub If I want EXCEL to run it when this workbook is open,how can I do that by VBA...

You could format it to not show the time, but maybe better would be to use =today(). Mark wrote: > > >-----Original Message----- > >Mark wrote: > >> How do...

I have a spreadsheet that has a number of list boxes which when I try to select from them won't respond. It's like they don't exist. I can go into design...

See one guess at your other post in .misc. Uday Jakati wrote: > > Hi, > I am working on a product which runs on different OS like > English, German, French,...

Take a look at Chip Pearson's instructions: http://www.cpearson.com/excel/ontime.htm Lorenzo wrote: > > Hello - I really hope you can help: I work for a...

Duane - I'm definitely interested in your sample Excel with serial VBA. Could you send it to me? I have Ofiice 2000 Professional edition - how do I know I...

There have been some posting about this problem, but I've never seen a cause pinpointed. Dave Peterson suggests a couple of fixes in the following thread: ...

Yep. I don't have a solution. And sometimes minimizing the worksheet window (or the application window) will bring them back, too. (When it does,...

I have a table with a column of user selected List boxes, e.g.: Listbox1 Listbox2 Listbox3 ListBox4 ListBox5 ListBox6 The listboxes can be used to select...

I am writing an Excel program to distribute to my clients in the water biz. I'd like to know if I need to include code to adjust screen or window sizes to...

Hi Rohit, Here's one way to do it: Dim ecode As Range Dim rngTable As Range With ActiveSheet Set rngTable = .Range(.Range("H4"), _ ...

Something like this will cause the icon to flash in the windows start bar: Option Explicit Sub testme() Application.Wait Now + TimeSerial(0, 0, 5) ...

I'm trying to have a loop to open a set of workbook one at a time to sort and copy some data out and then close it. The following code ONLY works for the...