Recent content by tim91700

Thanks, I know how to find a sheet name with partial informations. Your idea is to list the h:h.cellname in a tab, and check is the F3.value exist. If yes, I get the value of the cell. Here is a part of the solution : Sub Test() Dim r As Range Dim cell As Range Dim n As String...

Thanks, that exactly what i'm looking for. But the name need to be equal to the value Now, if h3.name is test, f3.value is tes, I want to find the value of h3. I mean, I want to work with approx name, like begin and end by. I'm sure about the value of F3 but not the H3.name. Because there is...

Hello, Thanks for details, but the H3 name need to be "test", his value is equal to a number of line, like 100. The aim is to dispatch some informations from another sheet, iincrement this number, and do something.

Hello, Take an excel document, name the cell H3 as "test" (without " ") Put "tes" (without " ") in the cell F3 as a cell value The aim of the sub, is to take the F3.Value, and the range H1:H100, and find the value of the cell H3. I find a code to find the value, but not with the cell name...

Hello, I'm a french student, with a partial job as an system admin. I love crowdfunding and techno music. I learn the vba for a project, to transform mulitple inventories to one. Thanks for your help