Search results for query: *

Hi all folks, this time I've a problem related to the research of a some kind of string in a range, here it is: in column A I've got 10.000 cells with this kind of values (the format of the cell is Text): A1 = 10.1 A2 = 10.11 A3 = 10.12.0 A4 = 10.12.00 I want to fill all the cells that have...

Hi guys, I've got a column in which are entered different values. I want to create a sub that choose the maximun of these values and that will fill the cell with red color. I want to do this through the Worksheet_change (ByVal Target As Range) event, so every time that a value is entered in the...

Hi all folks, I have a problem with the date format in a userform: I've designed this simple UF to manage the annual expense about to car costs. The UF works well, you insert the type of cost, the ammount and the date of the cost. Nut when I press the OK button to insert the data in the...

Hi there guys, it's been a long time since I wrote on the forum. I've got a problem with a UserForm_ListBox. I created a UF with 2 listbox that have 3 columns each. Once selected a row, with a double clik event, I want that the values of the selected row to be put in a precise range of the...

Hi everybody folks, I've a urgent problem with a macro, must send the work in two days please help me! Here's the problem: I've got a sub with 3 big different with...end with structure, and each one of them contains some if statements. I've built the sub in a way that to run correctly you...

Hi guys, here's my problem: I must copy some cells that are not adjacent one to another located in column A, to column F. With my sub I search for every cell that is font.bold = true, and once fuond i must copy it in cell F1, than the next cell found with font.bold=true in F2 and so on...

Hi everybody, I just joined the forum, mi name in Nic and I come from Italy. Here's my question, hope someone could help me! I got a range("A1:A20") in sheet2, each cell has a value of this kind: 50.20.00 P, 49.13.00 P and so on...for a total of 20 different values. Now I want to search for...