OzGrid Free Excel/VBA Help Forum

Có thể chỉnh sửa giúp em về lỗi này dc k ạ
Phạm vi ("E18: E23"). Chọn
Lựa chọn. Sao chép
Selection.ShapeRange.Item (1) .Hyperlink.Follow NewWindow: = False, AddHistory _
: = Đúng

(Quote from Akhas)

Didn't work for me. Can you please explain this to me step by step guide ?

Thank You S O

I am attaching the file (First Sample File.xlsm) for better understanding.


Thank you again.

Hi, welcome to OzGrid!

It would help if you could provide a worksheet that has an example of the data you are using, this helps to see the problem and create a better solution.

Kind regards,

S O

Perhaps provide us questions and answers so we can check? ( this being said, I think hi-jacking old threads is not encouraged in forums)..

See the new formula with the yellow background, making use of SUMPRODUCT
BTW, are the blank rows necessary? If not they can be removed and you can make your range an Excel Table.
Then rebuild the formulas provided using the table references, so that in the…

Hi.

I have worksheets with lots of data and various related certificates in the drive location. The fact is I want to create a hyperlink. Now, how the hyperlink create?

The File Location folder is D:\Certificate\ where the file name is like 5.…

Hi, Hope All Are Fine.

I have a worksheet where I want to input date to a specific column of the selected cell if I click on a command button.
The selection data range F10 to F1200 & the date input column is AW

The procedure is :
If I select some cell in…

Hello -

I'm trying to find Weighted Averages of Column C and D, by letter in Column A.

As the placement of this file will change, how can I find weighted averages of the rates without having to use SUMPROD in specific ranges, since placement will change…

Hi Crabmano,

I am writing to you regarding the exercise you post few years ago about and excel exercises.

Could you please send me the answers of the 5 questions