Question

1
Replies
1012
Views
Jayachandra Reddy K Member since 2017 23 posts
Infosys
Posted: 3 years ago
Last activity: 3 years 5 months ago
Closed
Solved

Excel - Find value using UsedRange in automation

Hi,

I want to check the value is exist or not in the excel. for ex: if user enters value in the textbox and then I will check whether this value is exists in excel or not. So, I used .net code as below.

Microsoft.Office.Interop.Excel.Range selectedRow = xlWorkSheet.UsedRange.Find(textBox1.Text, ................);

Instead of .net code how to find the value using usedrange as per attached image.

**Moderation Team has archived post**

This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.

Robotic Process Automation
Moderation Team has archived post
Share this page LinkedIn