Hi,
I am trying to write a macro to do the following:
Search column "I" for blank cells. If one is found then all adjacent cells to the left in that row are shifted to the right by one. (in other words for that row cells A-H are shifted right to become cells B-I).
Hope that is clear - Thanks in advance for any help!
BirdS
Last edited by VBA Noob; 11-02-2008 at 02:36 PM.
Does this work for you
VBA Noob
Please Login or Register to view this content.
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
Perfect!
many thanks
Hey I need a similar help. I am new to VBA. I am trying to search column D for empty cells. if it is empty then i want the row below it to move up and occupy the empty space but not the entire row to move up. more like 5 colums around the empty cell to move Is it possible?
example.jpg
This is an example of what i want to do. Could someone pls help me
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks