-
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
- 255 limit isblank
- 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
- 255 limit body hyperlink mailto subject
- 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
- 255 limit ado excel vba
- Replies: 0
- Forum: Excel Questions
Some videos you may like
This Week's Hot Topics
-
Dynamic cell and sorting
- Started by Polanskiman
- Replies: 31
So here is the deal. I need that cell in E4 to be dynamic because the "Description" column on the Excel table is supposed to be sortable. By... -
How do I get combobox to get a cell number then link it to a selection from a checkbox in Excel?
- Started by Ayugma
- Replies: 31
I have no idea how to really implement this. So I have 5 checkboxes, all of which are parts to a machine. So, a user will be able to select as... -
VBA code works on works desktop but not on my own laptop
- Started by Monojono
- Replies: 30
Hello Readers and hopefully problem solvers, I have a large amount of coding across my workbook that works fine on my works desktop. However, on... -
Formulas referencing Pay Dates in year
- Started by rishijain11
- Replies: 27
Hi, I'm trying to build out this excel file to keep track of my finances. I could use some help with several formulas revolving around the pay... -
Sorting key
- Started by dpaton05
- Replies: 25
When you are sorting using range.sort method, one of the parameters is Key. If I want to sort by column A, with the header being in row 3 and the... -
Copy Range of Cells And Paste Until Last Row
- Started by Unexpc
- Replies: 21
Hi guys i have a page in range A41:H74 and i want copy this page and paste until last row of excel sheet. does any vba code to do this?