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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Excell Cell Reference
Hi skip ought and mintjulep Many thanks for your help and quick response Much appreciated- AVAYANUS
- Post #16
- Forum: Microsoft: Office
-
-
-
Excell Cell Reference
Skip Many Thanks It works apart form the fact it results in an absolute cell reference. Is there any way to remove the dollar signs Thanks again- AVAYANUS
- Post #5
- Forum: Microsoft: Office
-
Excell Cell Reference
Can someone please help with the following. I am trying to write a formula that tells a user to fill in a cell (that is Blank)so it goes something like this. If cell B20 is blank then "Please complete B20" else "Cell B20 is complete" The formula looks like this =IF(ISBLANK(B20),"Please...- AVAYANUS
- Thread
- Replies: 17
- Forum: Microsoft: Office
-
Excel newline formatting to Outlook Email Body and keep format
PHV Many thanks for the response - It works- AVAYANUS
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Excel newline formatting to Outlook Email Body and keep format
Hello I'm hoping you can help with the following. I have created code to create an Outlook email from excel which works fine. The body of the email pulls it's text from a cell in excel and this generally works fine. The excel cell (B20) has new lines and reads something like this..... 1.Went...- AVAYANUS
- Thread
- Replies: 2
- Forum: VBA Visual Basic for Applications (Microsoft)
