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...
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 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...