Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
write value to a range in a user defined function
Hi All, Thanks for response. electricpete's code is working fine. A slight issue is when the upper cell is not empty, the array function will delete the value in upper cell. Combo, thanks for sharing the comment properties. The "AddComment" is actually working fine in my code. The only...- tt9527
- Post #8
- Forum: VBA Visual Basic for Applications (Microsoft)
-
write value to a range in a user defined function
Hi All, I am new to VBA so my question can be really basic. I need to create a user defined function in Excel that places a header in the cell above the function, if the cell above the function is empty. e.g. If you place =theFunction() is cell B1 and A1 is empty, it will write "The Function:"...- tt9527
- Thread
- Replies: 9
- Forum: VBA Visual Basic for Applications (Microsoft)
