I am creating a report using VBA Excel. Everything works fine until I use the ActiveWorkbook. Save command. At that point the system inserts:
"<Crystal Addin Version="1">" into cell V1.
This is off-screen from the report, but when I go to print the report, it causes extra pages to print.
I have tried both deleting the "V" column and clearing the V1 cell, which works until the...
User Profile
Collapse
-
Get rid of Crystal message in V1
-
VBA Excel Find with Count
Thanks! This is just what I need. I'll tweak it a bit to make it a reusable function and I should be good to go. Thanks for your help. -
VBA Excel Find with Count
OK. Let's try this again. I'm attaching a zipped file....Leave a comment:
-
Sorry - the attachment isn't formatted very well. I don't know how to get around this.Leave a comment:
-
VBA Excel Finds with Count
I'm attaching a sample worksheet. The code I need will find an exact match in column "E", for example "SR032526" and search the text in column "D" for a specified string - perhaps "SERVICES". With these examples, I would need a function that returned 2, which is the number of rows (row 3 and row 5) that meet those criteria. Thanks....Leave a comment:
-
VBA Excel Find in 2 Column with Count
I'm lost here. I need to count the number or rows that contain different text. In one column, it will be an exact match to the cell. In the other column, the text will be contained within the cell. I'm guessing that I want to create a function that will accept the name of the worksheet and the two search strings and return the count. Any help would be appreciated. -
HI. When I specified the worksheet name in the format you specified it worked with no problems. Thanks for your help....Leave a comment:
-
Thanks QVeen72. When I included the worksheet name in the format you indicated it worked with no problems.Leave a comment:
-
Why is VBA Excel not finding checkbox object?
I have added 4 checkboxes to a spreadsheet and want my macro to check the value of each one. When I step through the macro to the If statement below, I get an error message saying that the object is required. I'm new to VBA and not sure if the problem is there or on the Excel side.
If CheckBox1.Value = False Then
I have tried putting the spreadhsheet name in front of the checkbox name
eg - If MAIN.CheckBox1. Value...
No activity results to display
Show More
Leave a comment: