Search results

Hi It is not possible to give a new table a user selected name, but can be changed only afterwards. I would like to use vba to look at selected table, and change name to a specific cell value (name), say Tbl_sales (in say B14) That is once the table is selected then run the macro. Thanks...

Hi Oops I will have a look and try out. Thanks Charles

AllGW Thanks for your comments. Does not work quite the way I would like it. Do not want to have comment attached to a cell and want the textbox or whatever on screen all the time. Thanks Charles

With a workbook that has several users simultaneously, not all in the same room etc., want to be able for each sheet user to message a master sheet user and in reverse as well, with info. Very similar to the sms messages on a smart phone, basically 2 columns with in and out comments. Is there...

Hi Just setting up a simple workbook with a sheet that records data. Will have a user form. Details from this sheet will be sent daily by email to the main workbook below. The main workbook is on a PC computer using Win10 and XL2013. The issue is that the company wants to use Android...

Hi In attached WB there are 2 macros named testsendkeys () and testsendkeys1(). The first one works ok and places data into the Notebook. It uses a .exe file obtained from here: http://orlando.mvps.org/SendKeysMore.asp?IdC=OrlMoreWin2 Have tried to contact site but with no success. With the...

Hi Smallman Thanks for your comments. My apologies for not making clear enough. I am attaching the workbook again, this time it has a lot of comments and details on before and after. The main thing I am looking for at the moment is to know if the macro is using the correct numbers, my...

Hi I am setting a variable etc. The loc1 is a dynamic named range, storing integers starting at G5 there is a changing total number of entries in it. Another Macro will have to get the value in each row and then use it in a subroutine Sub CheckingVariable Dim LastRow As Long Dim i As Long...

Hi Narayan Thanks for your great explanation. I will go and look at my workbook. I may find some info at row 65536 ! You explained very well and I will stay with the xlUp version. Thankyou for your help. I have learnt lots about ontime, repeats, and xlUp, xlDown, etc Thankyou Chuck

Hi Got it working with this xlup code off the net. But the xldown seems to be more simple if I can get it working. ** Range(Range("n15"), Range("n65536").End(xlUp)).Copy Destination:=Range("o65536").End(xlUp).Offset(1, 0) ** Thanks Chuck

Hi Narayan Yes, you are correct as per your last line. I have removed the (2) and it step thru is ok. But nothing seems to happen at all. It is in a module (4) General. Excel 2000 ***** Sub RefreshDataOne() Range("N15").Copy Destination:=Range("O15").End(xlDown) End Sub...

Hello Narayan and ASA Thanks for your input. The Time Serial change is magic. Works very well. Thanks. Narayan you fixed the code in the refreshdata macro to one line, and it works great. I would now like to paste it into the next available row starting at O15. Have used your code with...

Hi Narayan No there will be keypresses happening and also some macros will need to run during this time. With the OnTime with running say 10 seconds is this a once only event or does it keep repeating. I need only a single event as the For X covers the repeats. Thnaks Charlie

Hi Changed the ontime to Now (from Date) andthis takes 10 seconds for first copy, but no more. Chuck

Hi Narayan The new code for copy/paste is great and works well. With code to run the macro 5 times etc, just checking again, it runs immediately the macro is run, does not wait the 10 seconds. And probably does the five actions then. What needs to be done to wait 10 seconds, run code...

Hi Still not quite ok. I am copy/paste value from G15 to n15 every 10 seconds for 5 times. When I 'step thru' code ok. When I run the repeat code it does the first one ok. I then change the value in G15 expecting it to be placed in N15 with the next repeat. But no it does not. Code is...

Hello Must have a slight error in the workbook. Thanks for your help. Surpised myself that it does work. Chuck

Hello I have a macro that needs to be run every say 10 seconds and for a set number of times, say 5. I have tried to combine the two types of code, timeon and repeat codes. Not quite correct yet. Anyone able to assist. Run every 10 seconds for in this case 5 times "RefreshData" is the...