Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with getting Values
Hello. I am trying to make a simple function that will automatically fill in
data if a few Cells are not blank. I'd very much like to do this with a function but if need be I'll struggle with working with Sub Code. I am trying to keep this very readable in Microsoft Excel and I'd really only like to pass in two variables if it is posssable. My code thus far (which doesn't work because I am guessing Application.Indirect doesn't work) is: Function AutoFill(RowNum, TrueFill) If (Application.Indirect("Y" & RowNum)) < "" Then AutoFill = TrueFill Else If (Application.indirect("B" & RowNum) = "") And (Application.indirect("B" & (RowNum + 1)) = "") Then AutoFill = "---" Else AutoFill = "" End If End If End Function Where RowNum is the Row Number without the column letter and TrueFill is what will be filled into the cell if the certain cells are not blank. I need the program to check if columns B and Y are filled with something on that row as well as Column B of the next row. If any of you know of some code that will help me do this I will be very greatful. Thank you for your time. Mark |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with getting Values
If you are trying to check the value in a cell then instead of :
Application.Indirect("Y" & RowNum) try: Range("Y"& RowNun).Value -- Gary's Student "Abode" wrote: Hello. I am trying to make a simple function that will automatically fill in data if a few Cells are not blank. I'd very much like to do this with a function but if need be I'll struggle with working with Sub Code. I am trying to keep this very readable in Microsoft Excel and I'd really only like to pass in two variables if it is posssable. My code thus far (which doesn't work because I am guessing Application.Indirect doesn't work) is: Function AutoFill(RowNum, TrueFill) If (Application.Indirect("Y" & RowNum)) < "" Then AutoFill = TrueFill Else If (Application.indirect("B" & RowNum) = "") And (Application.indirect("B" & (RowNum + 1)) = "") Then AutoFill = "---" Else AutoFill = "" End If End If End Function Where RowNum is the Row Number without the column letter and TrueFill is what will be filled into the cell if the certain cells are not blank. I need the program to check if columns B and Y are filled with something on that row as well as Column B of the next row. If any of you know of some code that will help me do this I will be very greatful. Thank you for your time. Mark |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with getting Values
Thank you very much. That worked perfectly. Plus it led me to another
update in the code I probably would have asked help for anyway. "Gary''s Student" wrote: If you are trying to check the value in a cell then instead of : Application.Indirect("Y" & RowNum) try: Range("Y"& RowNun).Value -- Gary's Student "Abode" wrote: Hello. I am trying to make a simple function that will automatically fill in data if a few Cells are not blank. I'd very much like to do this with a function but if need be I'll struggle with working with Sub Code. I am trying to keep this very readable in Microsoft Excel and I'd really only like to pass in two variables if it is posssable. My code thus far (which doesn't work because I am guessing Application.Indirect doesn't work) is: Function AutoFill(RowNum, TrueFill) If (Application.Indirect("Y" & RowNum)) < "" Then AutoFill = TrueFill Else If (Application.indirect("B" & RowNum) = "") And (Application.indirect("B" & (RowNum + 1)) = "") Then AutoFill = "---" Else AutoFill = "" End If End If End Function Where RowNum is the Row Number without the column letter and TrueFill is what will be filled into the cell if the certain cells are not blank. I need the program to check if columns B and Y are filled with something on that row as well as Column B of the next row. If any of you know of some code that will help me do this I will be very greatful. Thank you for your time. Mark |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with getting Values
You are very welcome.
-- Gary's Student "Abode" wrote: Thank you very much. That worked perfectly. Plus it led me to another update in the code I probably would have asked help for anyway. "Gary''s Student" wrote: If you are trying to check the value in a cell then instead of : Application.Indirect("Y" & RowNum) try: Range("Y"& RowNun).Value -- Gary's Student "Abode" wrote: Hello. I am trying to make a simple function that will automatically fill in data if a few Cells are not blank. I'd very much like to do this with a function but if need be I'll struggle with working with Sub Code. I am trying to keep this very readable in Microsoft Excel and I'd really only like to pass in two variables if it is posssable. My code thus far (which doesn't work because I am guessing Application.Indirect doesn't work) is: Function AutoFill(RowNum, TrueFill) If (Application.Indirect("Y" & RowNum)) < "" Then AutoFill = TrueFill Else If (Application.indirect("B" & RowNum) = "") And (Application.indirect("B" & (RowNum + 1)) = "") Then AutoFill = "---" Else AutoFill = "" End If End If End Function Where RowNum is the Row Number without the column letter and TrueFill is what will be filled into the cell if the certain cells are not blank. I need the program to check if columns B and Y are filled with something on that row as well as Column B of the next row. If any of you know of some code that will help me do this I will be very greatful. Thank you for your time. Mark |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 doesnt show Y-axis values when the values are small. | Charts and Charting in Excel | |||
Exclude #N/A values and Return Numeric values to consecutive cells in Single Row | Excel Worksheet Functions | |||
Search/Filter to find values in another range based on two cell values | Excel Programming | |||
How do I search thr'o column and put unique values in differnt sheet and sum corresponding values in | Excel Programming | |||
Predict Y-values on new X-values based on other actual X and Y values? | Excel Programming |