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