cell1

Hello! I'm working on a code and have come upon something that I hope has an easy way to do. In it, there are 3 cells in the workbook. Each cell can only have 1 of 3 possible string values in it. For this example say A, B or C. Depending on the combination of letter, they receive a different...

Seems there's always trouble with date values. Maybe it's more frequent in non-english countries due to locale settings? I don't know, but either way date conversions is a real pain. I was sent an excel sheet from a colleague at work today. He has date as text a cell ...let's call it cell1. The...

Hello I have a macro that help me to extract some data from text files and put on a table in Excel. The macro is working, adapted by me from old one. Sometimes I have hundreds of txt files and since the macro is not the fastest on my laptop I don't know how many files are processed/remains. I...

Hello, I like to copy row based on multiple conditions and I hacve a problem with letters. I like to check if cell in column O contains letters P and R, and if so, copy row to next sheet. my code is (with not working P and R) Dim cell1 As RangeDim lastRow1 As Long, i As Long lastRow1 =...

Hi, I have the following scenario: Cell1=6.99 Cell2=6.99 Lookup range contains value 6.99 Cell1 and Cell2 both have same format and contain the value of another lookup formula. The MATCH function returns #N/A for Cell1, but not for Cell2. When I check equality with =Cell1=Cell2 and...