-
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.
dim as byte
-
B
VBA script takes multiple passes to fully work
Hey Gang, I have put together the following script to help me delete links that are hidden within ConditionalFormats. This is to break those links that the "Edit Links" wizard can't do. It "works" but I have found that on some of my workbooks; I have to go through a couple passes to eliminate...- Beyond_avarice
- Thread
- Replies: 8
- Forum: Excel Questions
-
S
Dim as Byte versus Dim as String
What is the effect if I Dim as Byte a String data type value? I know that it will generate a Type Mismatch error, which can be countered by an Error Handling line. <o:p> </o:p> I am asking, because the “as Byte” variable executed my macro really fast as compared to when I use the “as String”...- SMB Cooper
- Thread
- Replies: 5
- Forum: Excel Questions
Some videos you may like
This Week's Hot Topics
-
Copy dates from one sheet to another in range if date is old than 11 months
- Started by DanSMT
- Replies: 36
I am having an issue pulling dates from one workbook.sheet to another workbook.sheet. I've been working through the code. not sure if this is... -
Date and reference number being inserted into footer after the first page
- Started by dpaton05
- Replies: 37
How do I put things into the footer on all pages after the first using vba? -
Highlight Adjacent Cells in a grid
- Started by JLEMS
- Replies: 33
Hi. I am new here and I have been trying to figure out how to get a spreadsheet to do what I need it to, but have not found the exact way to get... -
Calculating lost hours per week
- Started by gd6noob
- Replies: 26
Hi there, I have a worksheet that calculates lost hours for employees. Basically it cells AE to CD are weeks 1 to 52 and it looks at the start... -
VBA Open .txt file with a string
- Started by ItalianPlatinum
- Replies: 25
I have a VBA code that works like a charm that displays a dialog box and allows a user to select a file. I am trying to enhance it to force the... -
Invalid qualifier
- Started by dpaton05
- Replies: 24
I have a procedure that moves some buttons. They need to be moved to just below the bottom of the last entry in column A. I get an error saying...