| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need help on moving to next column
I use this line of code to look for the data that I need:
Windows("MAPReport.xls").Activate Dim LastRowA As Long With Worksheets("Summary") LastRow = .Cells(.Rows.Count, "A").End(xlUp).Row With .Range("F2:F" & LastRow) .Formula = "=1+3" .Value = .Value End With End With But, how do I state that if F2:F is not empty go to the next available column (in this case column G)? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| moving part of a column into another column | Excel Worksheet Functions | |||
| Ron DeBruin Macro - Moving Sheet Name from Last Column to Column A | Excel Worksheet Functions | |||
| moving a row to a column | Excel Worksheet Functions | |||
| Why is my tab key moving my cursor from column A to column k? | Excel Discussion (Misc queries) | |||
| Freezing the data in a column and moving the calculations to the next column | Excel Programming | |||
Threaded Mode
