How to get a value of a cell next to a empty cell
Closed
mike
-
Apr 15, 2011 at 08:51 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jul 3, 2011 at 08:22 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jul 3, 2011 at 08:22 AM
Related:
- How to get a value of a cell next to a empty cell
- How to delete a cell in word - Guide
- Cell phone codes - Guide
- Excel cell color formula - Guide
- What function can automatically return the value in cell c77 - Excel Forum
- The following excel image has a vba program (see below). what will be the result after the program is executed? any cells not displayed are currently empty, and any cells with numbers are formatted numeric. sub afdo a=0 lastrow = cels(rows. count, 1). end(xdup). row for i =14 to lastrow step 2 a=a cellsii. 5) value next cells(lastrow 2, 1) value = "the sum - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jul 3, 2011 at 08:22 AM
Jul 3, 2011 at 08:22 AM
if you know the cell where the blank data is, then you can use offset to get where you want to go
