Search:

Hello,
I'm trying to use a User-Defined Variable for the first time. But got an error.
I placed the below Type statement at the top of "ThisWorkBook", then when run the code, I got:

Cannot...

By the way, the Named range "MyNamedRange" is merged cells .. I'm sure this could be relevant cause. But do not know how to solve it

The ws_name is a variable as I have more than a Worksheet with the same structure & named cells.
I tried the following codes just to make sure all variables are OK, and it worked perfectly except...

Hello,
Can someone support in the below please?
I have a Named range MyNamedRange "$C$2:$E$4"
I'm trying to clear the contents of that range using the below statement, but get an Error

Run-time...

Thanks a lot. Your way is working perfectly :)

Hello .. Can someone help me in this please?
I have more than 180 circles shape inserted in a worksheet. I need to change the filling color of specific circle once a condition is true.
I got...

Hey guys,

During VBA Excel code execution, I received Run-Time Error ‘13’: Type mismatch with two options: Debug or End. When selecting End, both Worksheet_Change and Worksheet_BeforeDoubleClick...

Thanks a lot westconn1 .. that works fine

Hey guys,
I'm looking for a VBA function to search for maximum in a column list including numbers and alphabets. But with specific criteria. Please see the below example:
I need to find the max...

Hello,
I'm a beginner in C++. I'm trying to call a function from a class called Complex which compares 2 complex numbers but I'm not sure how to assign the function and implement it. Here is what I...

I have list of countries (column B), names (Column Y), date of birth (Column S)
For each country, I need to get oldest person date of birth and his name. I got the Max birth date correctly .. but...

I'm using Microsoft Excel 365
I cant find the [Microsoft MonthView control 6.0 (SP4)] tool in More Controls list.

I tried the following steps:
>>Download the MSCOMCT2.OCX
>> copy MSCOMCT2.OCX...

Yes I have MAXA and MINA .. both return zero

I have a column list of Fiscal Years formatted as follows:

FY19
FY21
FY18
FY15
FY30
FY28
FY29

Thanks a lot .. It works

Hope there is a solution for my problem.
I have a big list if names in column A from “Sheet1”, most of these names are repeated more than once. I need to create a function in different worksheet...

Now it is working .. thanks a lot for your support.

When I run this code, I received the following message:
Cannot run the macro "......'!myend'. The macro may not be available in this workbook or all macros may be disabled.

Even though my...

I tried adding myselection = 0 after each procedure .. but still not working. I'm not sure if I've understood you correctly .. please see below:

Private Sub CommandButton1_Click()
Dim MySelection...

Hello,
This is my first try to use Application.OnKey
Would someone please help me in the following code. I have a command button on Sheet 1 the following is supposed to work, but it does not!!

...

I have 24 measurement values; I need to divide them into 4 optimized groups (6 measurements in each group) on condition that, each group average value has a minimum deviation from the total 24...

Dear Guys,
I'm using the below sub to copy some rows from a sheet to another one .. this is repeated hundreds times in my procedure. Is there any way to do the same without activating and selecting...

Thanks a lot dear GBeats and dear westconn1 for your help .. I'll try both ideas and use the working one :-)

Best regards,
mkshehata

Hello Guys,
I’m using the below VBA code to put (Page # of Total pages) in the footer of “Sheet1” and the same for “Sheet2”.
How to write a code to make “Sheet2” continue numbering after “Sheet1”...

Dear Guys,
I have 4 pictures inserted in a Worksheet, I need a VBA code to copy a specific one of them and past it in different Worksheet in case my condition is True.

Can anyone help me...

Hello Guys,
I'm using the below VBA code in Excel 2007 to allow end user to select a name and locate of an Excel file, then I will add some data to it.
The problem is the file name...

Thanks a lot TnTinMN
You solved my problem


Best regards,
MK Shehata

Hey Guys,
Just wondering if anyone knows how to do the followings using VBA in excel:

By clicking a Command Button, a new excel file to be created and the end users to be able to save the file to...

Thank you very much .. this is working

I'm using VBA in Excel 2007 and I need to clear a range of cells (to be defined by variables) in a specified worksheet.
Can anyone let me know why the following syntax is not working and creates...

Thank you so much dear TnTinMN
you solved my problem :-)

Hello,
I'm using VAB in MS-Excel Ver. 2007
I have a problem of passing arrays to a function. Once I try to excute the code, I receive the following error message:
"type mismatch: array or...