Search results for query: *

Hello, I have some questions on intersect code. I am trying to make the following code put a matched in range s2:s500 when a user double clicks on the cell. I would also like this code to be in workbook so when a user open excel the code works. For intersect code is it possible to change the...

Hello, I have the following code which attaches an file to an email and sends to a distribution list. The problem I have is that I want the email to pick up the same name as the file attachment. It can change the code to factor in a different attachment name due to date stamp. I wish to also...

Hello, I am writing a code which will check if price in column L is lower than column Y or greater than column Z. The following is aimed to loop through the ranges and turn the interior of cells in L red if the condition is false. If I could have some tips on how to re write the code for the IF...

Hello I am trying to select text in a range and if the case is met then have a statment placed in a second range. The problem is I can see the selection of range works but for the case nothing seems to fire. Could I have some pointers on my error please. Here is my code. Sub TEST() Dim LASTROW...

need to write a code that can open a file which is saved to a common drive a number of times per day using yesterday`s business date with a time stamp. The file format is saved as `FxData2608_09_26.xls`. (09 & 26 are hour and minutes respectively)The problem is that the file is never saved at...

Hello, Could someone help with code for DTPicker. I am trying to vba code a calendar using DTPicker. If there are any good references with examples someone could share that would be great.

Hello, I need to modify my code which I use for opening a file for today -1 however, I need the file to select the last business day excluding WEEKENDS. I am using this as a sub 'TO OPEN THE FILE TO FILTER AND COPY Dim yestdate As String yestdate = Format(Date - 1, "ddmm") & ".xls"...