byte

Where Z=length of string. Z can be 0 to 8. Each byte of the string will be a number between 0 and 9. I couldn't use a numeric field because 00100 becomes 100 and 00000001 becomes 1. The text string must have 1 byte for each time slot. I referee basketball. There are between 0 and 8 games in a...

Following are the instructions I've been provided by the manufacturer. I'm neither a developer nor knowledgeable about ascii, hex, or binary coding. I've found Excel and VBA SHA1 hashing algorithms (here) and tried to implement them. But for the test values provided I've never been able to...

Greetings Below Code for Lighten RGB How get Darken RGB? Sub lightenRGB() Dim I As Integer, Rng As Range Dim R As Byte, G As Byte, B As Byte Set Rng = Selection With Rng.Cells(1).Interior R = .Color Mod 256 G = .Color \ 256 Mod 256 B = .Color \ (CLng(256) * 256)...

Hi I've built a UDF that gets called on about 100 times for each of the 200 customers that I run through the model on various dates. It works 99% of the time but doesn't for the other few. On the instances where it doesn't work, it is working for some of that customer's dates but not others...

Thank you in advance for your help with my issue. I have an Excel spreadsheet that computes rows containing a 1-7 digit number, and 64 decimal cells that can contain values that range only from 0 to 255. For consumption in the end product the 64 cells need to be generated into a single cell...

I need to change the fill color for a column of cells based on RBG values. For example: <tbody> R/C A B C D 1 R G B Color 2 255 0 0 3 0 255 0 4 0 0 255 5 85 170 255 </tbody> In D2:D5, I'd like to set the fill color based on the RGB values in the cells in A:C of that row. I...

Hi All I have (what is probably) quite an unusual problem where I frequently need to measure the amount of single and double byte characters in an Excel cell. The reason for this is that Google allows a fixed number of characters for PPC such as ads but for double byte languages, it counts any...

i'm retrieving the cell color in a spreadsheet and assign it to a variable, then use the variable to color another cell. color_1 = .Cells.Find(what:="mycell", LookIn:=xlValues, lookat:=xlWhole, SearchOrder:=xlByColumns).Interior.Color .Cells(1, "A").Interior.Color = color_1 The code will...

weekdayname(Weekday as Long) Why there is a Long when there are only 7 days? Can BYTE wont suffice?