show a cell

		Microsoft Office Forums > Microsoft Excel > Excel Programming
show a cell

FAQ

Thread Tools

Display Modes

s7y show a cell 05-20-2012, 08:52 AM

macropod There are some variable here... 05-20-2012, 09:38 PM

s7y Howdy Paul, in reply to your... 05-21-2012, 06:49 AM

macropod You could use something like:... 05-21-2012, 06:18 PM

s7y Hi there Paul, can you please... 05-22-2012, 12:44 PM

macropod Have you run the macro... 05-22-2012, 02:44 PM

s7y I did run the macro but... 05-22-2012, 11:00 PM

macropod That implies some difference... 05-22-2012, 11:03 PM

s7y oh... ehmmm... yes... did I... 05-22-2012, 11:30 PM

s7y Paul, I checked the macro by... 05-22-2012, 11:38 PM

macropod That's a fairly major detail... 05-22-2012, 11:40 PM

s7y Data sheet has the greater... 05-22-2012, 11:51 PM

macropod In that case, it shouldn't... 05-23-2012, 12:55 AM

s7y Hello again Paul. I have... 05-23-2012, 08:57 AM

macropod What I said you should end up... 05-23-2012, 03:46 PM

s7y ah ok... tested and it... 05-24-2012, 07:30 AM

macropod I've already shown you how to... 05-24-2012, 04:54 PM

s7y Paul, the "Report" sheet... 05-25-2012, 02:44 AM

macropod Let me see if I understand... 05-25-2012, 03:02 AM

s7y In this case "24". 05-25-2012, 03:34 AM

macropod Try: Sub GetColRef() Dim i... 05-25-2012, 05:48 AM

s7y Hello Paul, When I run the... 05-25-2012, 12:32 PM

macropod The macro relies on the... 05-25-2012, 03:32 PM

s7y sorry about that Paul, I... 05-25-2012, 03:39 PM

macropod Until you post some sample... 05-25-2012, 04:51 PM

s7y Ok, here we go then. What I... 05-26-2012, 05:55 AM

macropod Hi S7y, Thanks for the... 05-26-2012, 08:00 PM

05-25-2012, 03:02 AM

macropod

Windows 7 64bit show a cell

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,502

Let me see if I understand this. Consider column I on your report sheet. The macro matches against 9821 in I16. So, what do you then want it to find - the highlighted '9' in I11 or the '24' in I20, or both?

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Can I create a formula that will show result in the same cell and let me copy it down	CranstC	Excel	1	02-11-2012 01:29 AM
How can I delete the content of a cell in column if the cell value is more than 1000?	Learner7	Excel	2	06-27-2011 05:44 AM
Question: Hyperlink to other show, but close the current show	habibfikri	PowerPoint	0	12-26-2010 02:37 AM
How can I fill cell color starting from Cell D5 using Conditional formatting instead	Learner7	Excel	0	07-08-2010 05:50 AM
Auto-populate an MS Word table cell with text from a diff cell?	dreamrthts	Word Tables	0	03-20-2009 01:49 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:53 PM.