code & vba

Hello Everyone Good day, I'm using below VBA code for last 1 years and today I discovered the small error in VBA code . When I write minus -10,000 it shows on "Only Hundred Ten Thousand" When I write positive 10,000 it shows on "Only Ten Thousand" works fine Can someone please correct my VBA...

Hi everyone, I'm not very experienced in VBA, but I found the following code in order to add time stamps to a workbook. However, I need the timestamps to be added to column D only. Currently, it applies the timestamps to ALL cells. Here is the code: Private Sub Worksheet_Change(ByVal Target...

I enjoy writing Code for Excel files. Is there any way I can ever sell an Excel file and protect it so that it can't just be copied and distributed freely to anyone who wants it?

Hi guys, Could you please help me with a code which would split Address string as per the pic attached? - there are two types of inputs: 1) the one which starts with "~" after ";" and is structured - i.e. has 3 strings (first two separated by "," + "~" country) and 2) the one which contains...

Been hunting the internet trying to figure this out and I give up so hopefully someone can help me out here. So overview is customer list and trying to break out customers by sales rep into their own sheets in the workbook. Just trying to set something up for a CRM while we are dealing with...

Hi All, I have the below piece of code which essentially takes data from one tab and makes it a bit more linear on another. So all the data (which is a timesheet) is on the timesheet tab. The code then changes it over to the history tab in a more linear form. Never had an issue with this until...

Hi, hoping someone can help. Think it's quite simple but I'm stuck! I have the following code which loops through a dropdown on Sheet1 and subsequently prints two other worksheets to PDF. Both worksheets have a cell linked to G5 on Sheet 1 and values in those worksheets should update based on...

Hi All, I have been using this code with success for generating emails, using VBA Set OutApp = CreateObject("Outlook.Application") Our company is moving to the web based Outlook email, Office 365. This causes the code to error Is there code which creates email when using Outlook 365? Any help...

I have an amazing macro that uses dialog boxes and allows you to select a column of data, and break it up into multiple columns based on a number of rows you select. Then output those columns starting in a cell of your choosing. Starts as: (I choose 2 rows per column) 1 2 3 4 5 Becomes: 1...

Hi all, we have the following data and want to convert in "date", we have tried Code 1 =TEXT(A1,"mm\/dd\/yyyy")+0 Code 2 =TEXT(G12,"mm/dd/yyyy") but problem not solved, pls check the result after using the above code and provide the code/vba, also when we copy the data...