-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
invalid data
-
D
hyperlink w/in excel loses reference
hyperlink w/in excel loses reference this is the situation person cell id hyperlink Adams b20 b20 Jones b50 b50 Zilch b99 b99 If I create a hyperlink at Zilch to Jones the hyperlink = b50 then if I add a person above Jones (b50), the Jones info moves down and...- dueker1
- Thread
- cell id hyperlink address invalid data
- Replies: 3
- Forum: Excel Questions
-
Q
Creating an "Invalid Hyperlink" warning
I'm looking for a list of characters that are invalid in a hyperlink address (at least as far as Excel is concerned). I have a form where the user can input a hyperlink address, and through VBA convert it to an active hyperlink. I've discovered that if the address has invalid characters (such...- quackdad
- Thread
- hyperlink invalid data
- Replies: 0
- Forum: Excel Questions
-
A
To Filter move out the Invalid data to a new sheet.
i have two sheets. Sheet 1 list contains orders & part nos. While the other contains the part no which are in stock. the format is as shown below. Sheet 1 Order no Part 1001 x 1002 y 1003 z 1004 x 1005 a Sheet 2 Part no Stock x 1 y 1...- aramdc
- Thread
- data validation filtering invalid data
- Replies: 3
- Forum: Excel Questions
Watch MrExcel Video
This Week's Hot Topics
-
VBA ARRAY CODE HELP
- Started by roykana
- Replies: 31
Dear all master, Please help for vba array code remove numbers based on specific contents of cell. ORIIGINAL [ATTACH type="full"]41084[/ATTACH]... -
VBA to find values in several columns, based on common value in a different column, then copy paste to different sheet
- Started by mlepesant
- Replies: 26
Hello, New to the forum. Good excel skills but almost no VBA experience. I have a file that provides me with Bill of material for different... -
Can someone help me understand the differences between dictionaries and arrays
- Started by dpaton05
- Replies: 23
I am struggling to understand the differences between when you should use a dictionary as opposed to when you should use a dictionary. Can someone... -
Auto add last entered data in same row
- Started by Detectiveclem
- Replies: 57
Hi can anyone help with a formula which will allow the last date entered in a row to be captured in the last date entered cell (E.G. Cell A2) And... -
Error with Loop
- Started by Jeeremy7
- Replies: 22
Hello, I have a problem with one of the loop I'm trying to do and I think it's in the formula but could somoene help me ? Also I saw that some... -
Check a number is between two columns and then pick a value
- Started by ashok89jan
- Replies: 20
I have the data like given below till Low =0.5, High= 1.49, and Grade = 1 My need is, if I enter a number in a different cell, say 95, I need that...
