如何在excel VBA中冻结列后显示最后3个填充列 [英] How to display last 3 filled columns after freezes column in excel VBA

问题描述

大家好，



我有一张excel表，其中前3列已冻结。在所有30列中，每天都有一个新列添加到最后。我想在前3个冻结列之后仅显示最后3列。这是excel vba。



我的搜索都向我展示了如何冻结这里不需要的列和行。



任何帮助都会非常有用.. !!



谢谢.. !!



我尝试了什么：



我的搜索都向我展示了如何冻结这里不需要的列和行。

Hi All,

I have an excel sheet where first 3 columns are in freeze. There are in all 30 columns and every day one new column in added at the end. I want to display only last 3 columns after first 3 frozen columns. This is in excel vba.

My searches are all showing me how to freeze columns and rows which is not needed here.

Any help would be very helpful..!!

Thanks..!!

What I have tried:

My searches are all showing me how to freeze columns and rows which is not needed here.

推荐答案

参见查找最后一列 [ ^ ]。如果您位于最右侧的列，则应显示最新的。

See Find The Last Column[^]. If you position at the rightmost column then the latest should be visible.

这篇关于如何在excel VBA中冻结列后显示最后3个填充列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！