Comment Delete
  Home FAQ Contact Sign in
 
 Advanced search
MATCHING GROUPS



more...
POPULAR GROUPS

more...
found 39704 articles for 0.958 sec
I don't know how you got the error. I've tested this and can't duplicate it. But if you're happy with the other subroutine, I'm not gonna worry about it. confused wrote: > > i'm not sure either. it works at first but when i sort my sheet the cell with > =echocomment(FCell,TCell) resolves to #VALUE. if i edit the cell it then > resolves back to a blank and works again. The macro version     

Group: microsoft.public.excel.misc · Group Profile · Search for Comment Delete in microsoft.public.excel.misc
Author: Dave Peterson
Date: Jul 24, 2008 14:22

i'm not sure either. it works at first but when i sort my sheet the cell with =echocomment(FCell,TCell) resolves to #VALUE. if i edit the cell it then resolves back to a blank and works again. The macro version will work for me because i don't necessarily need it to be dynamic but if you're curious here's an approximation of the pertinent info: in sheet1 i have a table and i want the text
Show full article (5.47Kb) · Show article thread
I don't understand how it caused an error. Maybe because the formulas don't point to the new location after the sort???? confused wrote: > > Many thanks to Gord Dibben and Dave Peterson!!! > You guys are awesome. > > Dave, I was stupidly inserting the code as an object on the specific sheet. > Thanks for the clafification. Great dynamic link for the comments (I'm sure > I'll be using     

Group: microsoft.public.excel.misc · Group Profile · Search for Comment Delete in microsoft.public.excel.misc
Author: confused
Date: Jul 24, 2008 14:13

Many thanks to Gord Dibben and Dave Peterson!!! You guys are awesome. Dave, I was stupidly inserting the code as an object on the specific sheet. Thanks for the clafification. Great dynamic link for the comments (I'm sure I'll be using it in the future) but it errored out if I resorted my sheet. Gord, worked like a charm. Wish it was dynamic instead of macro but this is fix i'm going with
Show full article (5.01Kb) · Show article thread
I'm sure it's user error but i can't get this to work. If I, for example, want to add a comment to cells A3 thru A100 that will display the contents off the corresponding cells by row in Z3 thru Z100 is this the best (read simplest) method? A3:A100 contain formulas, Z3:Z100 contain text. Thanks in advance for any help or clarification you can offer. "Dave Peterson" wrote: > You can use     

Group: microsoft.public.excel.misc · Group Profile · Search for Comment Delete in microsoft.public.excel.misc
Author: Dave Peterson
Date: Jul 24, 2008 11:08

On 18 Apr, 17:37, Dave Peterson <peter...@verizonXSPAM.net> wrote: Option Explicit sub Testme() Dim cCtr as long dim myCell as range dim myCol as range dim myArea as range dim myRng as range dim myAddr as string dim wks as worksheet myaddr = "a5:I10" cctr = 0 for each wks in activeworkbook.worksheets   Set myrng = wks.range(myaddr)   for each myarea
Show full article (3.36Kb) · Show article thread
Option Explicit sub Testme() Dim cCtr as long dim myCell as range dim myCol as range dim myArea as range dim myRng as range dim myAddr as string dim wks as worksheet myaddr = "a5:I10" cctr = 0 for each wks in activeworkbook.worksheets Set myrng = wks.range(myaddr) for each myarea in myrng.areas for each myCol in myarea.columns for each mycell in mycol.cells     

Group: microsoft.public.excel.misc · Group Profile · Search for Comment Delete in microsoft.public.excel.misc
Author: confused
Date: Jul 24, 2008 09:14

It looks like rather than "sequentially" populating the Comment fields, you are simply putting the cell's address into the Comment field. If that observation is correct, then I do not know what you mean when you said "when I get to i10 I want the sequence to carry over to the next sheet"? Do you simply want to put the cell address into each cell with the Range("A5:I10") on each sheet? If
Show full article (3.04Kb) · Show article thread
A really simple solution to allow new comments but not allow old comments to be destroyed is to create a related table to handle the many comments entered over time. This table has fields like this: NoteID AutoNumber primary key FKID Number which ID from the main table this comment is for UserID who entered this comment NoteDate     

Group: microsoft.public.excel.misc · Group Profile · Search for Comment Delete in microsoft.public.excel.misc
Author: confused
Date: Jul 23, 2008 12:34

Show full article (1.98Kb) · Show article thread
    

Group: microsoft.public.excel · Group Profile · Search for Comment Delete in microsoft.public.excel
Author: NickTheBatMan
Date: Apr 19, 2008 02:01

Show full article (1.65Kb) · Show article thread
    

Group: microsoft.public.excel · Group Profile · Search for Comment Delete in microsoft.public.excel
Author: Dave Peterson
Date: Apr 18, 2008 09:37

Show full article (1.34Kb) · Show article thread
    

Group: microsoft.public.excel · Group Profile · Search for Comment Delete in microsoft.public.excel
Author: Rick Rothstein (MVP - VB)
Date: Apr 18, 2008 09:22

Show full article (1.42Kb) · Show article thread
    

Group: macromedia.dreamweaver · Group Profile · Search for Comment Delete in macromedia.dreamweaver
Author: Danielcq
Date: Mar 25, 2008 18:15

Show full article (0.26Kb)
    

Group: microsoft.public.access.forms · Group Profile · Search for Comment Delete in microsoft.public.access.forms
Author: Allen Browne
Date: Mar 7, 2008 18:07

Show full article (2.85Kb) · Show article thread
1 · 2 · 3 · 4 · 5 · 6 · 7 · 8 · 9 · next