Hi,
I don't understand what you mean by heaving more cells in one row.
In the formula on post #2 you can change the interval according to the real situation.
If you can attach a file with the situation you refer to, I can help you. The UDF function really doesn't make sense here
Diana Tanase
If the solutions offered helped you to solve your problem, then mark the thread as SOLVED (thread tools in the top menu) and you can click on * to add reputation to those who helped you, as a way to say thank you !
Hello.
I received answer in another forum that has solved this issue so I'm sharing it below:
Instead of ActiveCell, use Application.ThisCell:
- returns the cell in which the user-defined function is being called from as a Range object.
Thank you tanasedn for your support and approach.
Public Function cellName() As String cellName = Application.ThisCell.Name.Name End Function
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks