semi-colon

Hello guys. I am new here and have tried to search for an answer that suits my needs, but to no avail. I have managed to do almost all I need it to do by copying functions from others suggestions here. Private Sub CommandButton1_Click() Dim content As String Dim rng As Range Set rng =...

I have just upgraded to office 365 for Business All my formulae now contain the semi-colon symbol instead of the comma symbol and I have to capture a formula now using the semi-colon. Is this a setting I need to change to continue using the comma? e.g. vlookup(A15, A7:C14, 3, false) now shows...

Hello, I have 1 Excel Cel (A1) with a long string of people email addresses without a bloody space. It's hard for me to insert this in Outlook without Outlook bombing out. The Cell is like this as an example: <tbody>...

I have 5 textboxes on a userform and I want to evaluate if they have text entered. The values are used as a 'CC' list for an email message, so I also need a semi-colon added after each textbox. Can someone show me how this could work?

I have a SharePoint list that I export into an Excel sheet. I run a macro that helps me quickly format this list into a printer friendly layout. I have one column though that includes the names of 1 to 6 people that I'm having a hard time formatting. If I have a single name in a cell, it appears...

Hi, I am trying to query a csv file using ADO. The procedure worked fine in the past, but I have recently received a new csv file that it doesn't want to read from. The only difference I can find between the old and new csv file is that if I open the old file in Notepad, the text just wraps...

Hello, Im very new to using the Visual-Basic Editor in Excel, I have been searching for a solution to my problem but could not find one. Ive got a file .skv type (semi-colon separated) that ive set to open with excel (I'm using 2000). I want the data from this file (5000 rows with 4 semi-colon...