cellvalue

Hi hope someone can help I have a vba that is working really well but i need to modify it slightly, currently it’s searching dependent on the value of a cell, searchvalue = reportsheet.Range (”C2”) .Value this works fine if the content in “C2” is exactly right, but I’m using for ref numbers...

I have a large data set with dates in column A, and alphanumeric strings in column B. I need to count the unique values in Column B between two dates in Column A. I've tried a few solutions, but due to the data size standard array formulas were freezing my workbook for 5-10 minutes. I found the...

Hello, I have a macro that is designed to print all text from Column A to print a list of all data except the blank cells. This is my macro, but it is not printing. I have it assigned to a Command Button. Is the print menu supposed to pop up or will it just print to my default printer? Is...

Dear All, I've been trying to write a excel macro (VBA) as below. My input : Excel sheet with multiple columns, and multiple rows Expected Output: Read from 2nd row, until reaches the end of the columns, and then write the read input to the file (.bat file) I need to read column title and...

Dear All, I've been trying to write a excel macro (VBA) as below. My input : Excel sheet with multiple columns, and multiple rows Expected Output: Read from 2nd row, until reaches the end of the columns, and then write the read input to the file (.bat file) I need to read column title and...

I need to create 1 PDF of 5 sheets (Sheet2 - Sheet7) File name needs to be value of cell "O1" in "Sheet2" File Path: "C:\Users\SP3\Dropbox (1 Stone Solutions)\1 Stone Solutions Team Folder\ Corporate\Hayden Smith\Sales Reporting\Weekly Sales Reports" I will be running the macro out of Sheet2...

Hi Boys & Girls, Please, help me.. I have this: ColumnA ColumnB SN qtty ac227 3 cz122 2 7787 4 And i need this: ColumnA ColumnB SN qtty ac227 3 ac228 ac229 cz122 2 cz123 7787 4 7788 7789...

Hello Forum-members, I'm having some hard time to achieve my goals for finishing a project where I need to query approx 500 URLs. Well, I could do things manually for each query, but maybe someone knows a way of repating things, as the queries only differ by the URLs...I would be very greatfull...