I am working with Excel 2007. I have created a worksheet which requires a signature to be embedded at the appropriate place. I can insert a signature in .jpg or .bmp format into a spare area of the worksheet but I then have two problems..
1. When I move the image to the area where the...
Istyak
Aaahh ! That's the way to do it !! Easy when you know how , eh ? Many thanks !
Just a question of how to adapt your technique into my spreadsheet.
But many thanks to those who also contributed.
Regards
Terry D.
Hi Narayan
I have resolved the problem to my satisfaction after a lot of thought and trial and error !
I inserted a text box in the worksheet then inserted the cursor within the text box. Then clicked on the formula bar , typed in = , moved to the cell that contained the text , date , value...
Narayan
Thanks for that but I do not understand how to do it ! Can you give me an example of how you think it would work ?
Is it clear from my question exactly what I am trying to do ?
Thanks in anticipation
Terry
I have a text box in one worksheet of a workbook which contains the following
"For the year ending 31 March 2014 , the company was entitled to exemption ..... etc etc"
I already have a cell in the worksheet which contains the phrase "year ending 31 March 2014".
Is it possible to insert in the...
Narayan
I have read your email as above and tried on two occasions to reply expressing my thanks to you and posing another question which is at the top of this new thread.
I tried to thank Narayan for his references to tutorials in my previous question but it would appear that my two attempts did not work. I hope that this one does and that someone can offer help in providing expressions in the attached spreadsheet.
Thanks for that , Narayan ! I have printed out two of those references you gave and I will have to do some homework !
In the meantime , I have another little teaser in the project I am doing which I cannot get my head round. I am attaching the file for you to look at.
Thanks for that ; it is just the job. The only problem is that I do not understand dynamic named ranges or how to use them or even create them.
Is there a tutorial that you can direct me to ?
I have a potential block of data say from B5 to N10. - see attached spreadsheet
Currently , there is data in B5 to I10 with Row 5 containing the date but the data block grows with time.
What would be the formula to put in cells P6 to P10 which will extract the contents of the latest column of...
I have a potential block of data say from B1 to AA10.
Currently , there is data in B1 to Z10 with Row 1 containing the date but the data block grows with time.
What would be the formula to determine the contents of the last column of each row i.e the contents of Z2, Z3 , Z4........ Z10 ?
In...
Sorry guys ! Forget the above post ! I got sidetracked with things going on at home before I had finished evaluating your other suggestions.
The Excel Date Picker/Pop-up Excel Calendar is excellent and works a treat but unfortunately , as you are aware , you can only get it as a trial before...
Thanks to all for your time and effort in your suggestions. I guess I may be looking for the impossible.
I have opted for the nearest method that I was looking for. I have created a worksheet with a column of 2 years dates e.g 24 Sep 2014 , 25 Sep 2014 etc. etc. and named the column containing...
Yes ! That was one of the many items I came across during my search and found it far too complicated to contemplate !
I am looking for something like simply formatting a range of cells each of which will display a calendar from which one can select a date which will appear in the cell.
I have tried searching the web for this answer but everything seems too complicated. I had one hit on a YouTube demo but it was too quick to follow and did not give any monologue.
I have a column of cells (20 -24 different dates) into which will be added a date from week to week. Format should...
Somendra
If my question was not clear enough , maybe I should try again !
In your last message , you said
"I had seen on Transfer sheet you have a IF formula which is filling the cell with a null string "" if found BLANK cells. Now count function counts "". That is the reason you are not...
Hi Somendra
Firstly , thanks so much for your time. It is much appreciated and , with great delight , I have to tell you that your suggested modification to the COUNTIF expression worked perfectly. Such a simple mod but it does the trick.
To answer your question about the macro. It is the...
Somendra
I was looking at the website and noticed that the reply that I sent you yesterday does not appear in the thread so I am sending it again.
My email yesterday said : -
I am taking the easy way out and sending the whole Workbook. The Workbook opens with an AUTOEXCE macro at the "Set...
I have produced an Excel Workbook which has various macros within it – developed with the help of people on this superb website. However , I have noticed a quirk which I cannot understand and therefore cannot correct ! HELP PLEASE !
The workbook is a leaderboard system for my golfclub which...
Hui
To get to Printer Preview setting
Either from Desktop
Start/Settings/Control Panel/Printer- Faxes/Canon iP4900Series/Printer/Printer Preferences/Main/... then Checkbox "Preview before Printing"
OR from within Excel
Page Layout/Page Setup/Options/Main ...... then
Checkbox "Preview...
After days of trial and error , I believe that I have eventually come to fully understand the background to the situation. Contributors have helped but none had FULLY explained the scenario.
The conclusion that I have come to is as follows :
BOTH the Printer AND EXCEL have a PrintView...
Sorry , SirJB7 , that doesn't work either ! I STILL get the Canon Preview window displayed with the option of 'Print' or 'Cancel print'
I hope that you will understand when I say , I give up ! It does not appear to be possible !
Thanks for trying.
I don't understand why you are Googling Canon iP4900 ! My printer is a Canon Pixma iP4950 so I would expect that to be indicated from Application.ActivePrinter !
Apart from that , ActiveSheet.PrintOut Preview:=False shows me the Canon IJ Preview window and will not print out the worksheet...