Current location - Loan Platform Complete Network - Big data management - In an excel datasheet, use VBA to change the value of column A which is not 1 to 2. It is required to be done in a single statement.
In an excel datasheet, use VBA to change the value of column A which is not 1 to 2. It is required to be done in a single statement.
Columns("a:a").Replace What:="1", Replacement:="2", LookAt:=xlPart, SearchOrder _

:=xlByRows, MatchCase:=False, SearchFormat:= False, ReplaceFormat:=False

It's the code that replaces the 1 in column A with a 2.

I hope this helps.

I hope it helps you.

Related articles
  • Tianjin Territorial Spatial Master Plan openly solicits opinions and suggestions
  • How banks store massive amounts of transaction data
  • As an old driver of APP operation, what good activity operation tools can I refer to?
  • How to check your own trip code
  • Is the stuff in the Ocean Terminal reliable, are they all genuine?
  • Psp great age of sail 4 nautical map iceland
  • What are the majors in Qiannan Vocational and Technical College
  • Are Bank of Jiangsu, Jiangsu Rural Commercial Bank and Jiangsu Rural Credit Cooperative one banking system?
  • What time does SF Express get off work?
  • Which is better, making and developing mobile app software (specializing in app software development company)?

    • copyright 2024 Loan Platform Complete Network All rights reserved