如何检索长度超过255个字符的range.address？ [英] How to retrieve range.address which is longer than 255 character?

问题描述

我很难找到超过255个字符的range.address。
我的范围由多个分段范围组成，其地址如下所示：
A1：B3，C4，K7：T6，A3：D3

I am having hard time with retrieving range.address which is longer than 255 characters. My range consists of multiple fragmented ranges, its address looks like this: "A1:B3, C4, K7:T6, A3:D3"

目前，我正在处理一个长度超过1000个字符的地址范围。令人遗憾的是，我无法使用range.address获取完整的地址。我只有255个第一个字符。

Currently I am working on a range with address longer than 1000 characters. The sad thing is I have not been able to get the full address with range.address. I got only 255 first character.

任何帮助都赞赏：）

顺便说一句， Microsoft通过 http://support.microsoft.com/kb/105416 。但是这是关于传递字符串，而不是关于返回字符串，所以...是的。

By the way, I have read Microsoft's work around on passing string longer than 255 chars at http://support.microsoft.com/kb/105416 . But that's about passing string, not about returning string, so...yeah.

推荐答案

我没有意识到有范围地址长度限制。类似于@Rory解决方案，我循环遍历范围区域，但我的解决方案使用返回长地址字符串的函数。

I didn't realize that there are limitation in range address length. Similarly to @Rory solution I loop through range areas but my solution uses function which returns long address string.

Function LongSelectionAddress(rngToGetAddress As Range) As String
    Dim LongAddress As String, rngArea As Range

    For Each rngArea In rngToGetAddress.Areas
        LongAddress = LongAddress & rngArea.Address & ","
    Next rngArea

    LongSelectionAddress = Left(LongAddress, Len(LongAddress) - 1)
End Function

这篇关于如何检索长度超过255个字符的range.address？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！