-
If you would like to post, please check out the MrExcel Message Board FAQ and click here to register.
If you forgot your password, you can reset your password.
255 limit
-
K
Getting a very complicated formula to calculate only if NOT(ISBLANK)
H4 is a date/time stamp I have saved as a macro. Returns 12/28/2011 10:47:00 AM. I4 is the same macro and returns 12/28/2011 10:48:00 AM J4 calculates the difference between the two (I4-J4), but only recognizes business hours and business days (Monday-Friday, 8:00 am to 5:00 pm) I only want...- kaldrazidrim
- Thread
- Replies: 1
- Forum: Excel Questions
-
S
255 Character Max in Hyperlink Mailto Body
Hello All! I am trying to write a hyperlink using mailto and the body of my email is ending up to be to long. Is there a work around that will allow me to use a longer body?...Also my subject is to long to....any ideas?- Schwimms
- Thread
- Replies: 5
- Forum: Excel Questions
-
G
ADO Recordset Data Limit
I'm using ADO to access a table in Excel and return data based on criteria, any data greater than 255 chars is simply cut at this point. Is there something I can include or use to get it to return the data (at least to the 1024 char limit). My code is below Thanks in advance. GTW Set cnnDD...- GandalfTheWhite
- Thread
- Replies: 0
- Forum: Excel Questions
Some videos you may like
This Week's Hot Topics
-
change colour of picture based on cell value
- Replies: 46
hello again guys I have found this video of Bills that explains how I could dynamically change the .width & .Height of a shape in excel, but I am... -
VBA - Combine Multiple workbooks into 1 worksheet
- Replies: 45
Hi, I am trying to write a VBA script which will combine multiple workbooks into 1 worksheet, copy and pasting all columns as values. Each sheet... -
Last Display on userform to a Listbox
- Replies: 35
[CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am... -
Vlookup and hlookup combination
- Replies: 28
Hello forum friends, I am using Excel 2016, XLOOKUP is not an option for me (I think). I have a worksheet that is linked to a website where the... -
Code giving run-time error when called, but not when placed on worksheet.
- Replies: 23
The code listed below runs on the worksheet, but gives a [B]Run-time error '424': Object required[/B] when called. I called the code, because when... -
Help with Current and highest streaks
- Replies: 23
Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...