joeny0706
11-29-2018, 11:09 AM
Hi All
I need to create visual basic command that I can use on an excel workbook. I need it to search all worksheets and make all negative numbers into positive numbers.
I did find one but it also made positive into negative. Cant have that.
and
Also another one I need is to fill a column saying "Passed" in each row based on another column with text. I am able to make ones that fill the column but then make the worksheet 60,000 rows or I need to pick a pre determined length.
Also at the same time to do on all the sheets.
I just started a new job. I have never worked with macros and visual basics. But I was asked to complete a task and since I am new I am trying to learn fast and get support from others
Maybe I should start a new thread but just asking you quick\\Again thanks for all the help
I need to create visual basic command that I can use on an excel workbook. I need it to search all worksheets and make all negative numbers into positive numbers.
I did find one but it also made positive into negative. Cant have that.
and
Also another one I need is to fill a column saying "Passed" in each row based on another column with text. I am able to make ones that fill the column but then make the worksheet 60,000 rows or I need to pick a pre determined length.
Also at the same time to do on all the sheets.
I just started a new job. I have never worked with macros and visual basics. But I was asked to complete a task and since I am new I am trying to learn fast and get support from others
Maybe I should start a new thread but just asking you quick\\Again thanks for all the help