Get value in active sheet

Morning every one,

I have a case user want to get data on active sheet only ,
because the file they get from another user so they can’t check and delete hidden sheet
So how i can use read range or something to get value in active sheet and don’t get value in hidden sheet ?
And i can’t get sheet name because it’s change every time user get it


Hi @LucastoH

Check attached, It will return active sheet name, so that you use that variable in Read Range (14.2 KB)

Mark as solution, If this helps you