excel - Type Mismatch error -

-

i have below code giving me run time error 13, type mismatch on line "if ws1.cells(i,13)="yes" then" column (column m) contains either blank cells, or "yes". i've tried redefining "i" string, , didn't change anything. goal every row "yes" in column m, entire row copied on second sheet named "output". error appreciated, open other ideas may suit goal. thanks!

  sub sadface()   dim ws1 worksheet: set ws1 = thisworkbook.sheets("trades")   dim ws2 worksheet: set ws2 = thisworkbook.sheets("output")    = 2 ws1.range("m65536").end(xlup).row   if ws1.cells(i, 13) = "yes"   ws1.rows(i).copy ws2.rows(ws2.cells(ws2.rows.count, 2).end(xlup).row + 1)   end if   next    end sub

it sounds if have manually removed errors external data. if bringing data workbook operation repeated on regular basis, may wish automate it.

sub happyface()     dim long     dim ws1 worksheet: set ws1 = thisworkbook.sheets("trades")     dim ws2 worksheet: set ws2 = thisworkbook.sheets("output")      ws1.columns(13)         on error resume next         .specialcells(xlcelltypeconstants, xlerrors).clearcontents         .specialcells(xlcelltypeformulas, xlerrors).clearcontents         err.clear         on error goto 0     end      ws1         = 2 .cells(rows.count, "m").end(xlup).row             if .cells(i, 13) = "yes"                 .rows(i).copy ws2.rows(ws2.cells(ws2.rows.count, 2).end(xlup).row + 1)             end if         next     end  end sub

as try avoid use of on error resume next¹, expedient method of dealing range.specialcells method when not sure whether exist or not.

¹the concept of breaking see if exists has seemed plain wrong me.


Comments

Post a Comment

Popular posts from this blog

python - TypeError: start must be a integer -

-
i trying draw 5 turtles, getting typeerror on line 25. here code: import turtle wn = turtle.screen() redrose = turtle.turtle() color = input("what background color be?") fillcolor_f = input("what color of rose be?") redrose.hideturtle() redrose.speed(30) redrose.penup() redrose.left(180) redrose.forward(175) redrose.right(90) redrose.forward(30) redrose.right(90) redrose.pendown() def drawrose(red): redrose.color("pink") redrose.fillcolor(fillcolor_f) redrose.fill(true) in range(red): redrose.forward(i) redrose.right(49) in range(5): drawrose(redrose) redrose.penup() redrose.forward(350) redrose.right(144) redrose.pendown() redrose.fill(false) drawrose(50) wn.bgcolor(color) i trying draw 5 roses, produces errors. doing in interactivepython.org. you recursively calling drawrose wrong parameter. on line 23 ( for in range(red): ) expect red integer...
Read more

c# - DevExpress RepositoryItemComboBox BackColor property ignored -

-
i have following code almost works properly; private void cbstatus_drawitem(object sender, listboxdrawitemeventargs e) { string item = e.item string; if (item != null) { switch (item) { case "1": e.appearance.forecolor = color.green; e.appearance.backcolor = color.green; break; case "2": e.appearance.forecolor = color.orange; e.appearance.backcolor = color.orange; break; case "3": e.appearance.forecolor = color.red; e.appearance.backcolor = color.red; break; } } } when dropdown shown, items forecolor correct, backcolor remains whatever backcolor of theme is; i.e. if i've got set dark theme, backcolor dark, cells in gridview, rather being green/orange/red. i've tried setting e.appearance.options.usebackcolor trying set e....
Read more

django - Creating multiple model instances in DRF3 -

-
1) create multiple model instances 1 api call, asked here: how create multiple model instances django rest framework? tried solution named in link, no success. i trying upload multiple files in 1 api call. result: files uploaded (only once overwrote perform_create) 1 instance created (if send 2 files, latter created instance). my code: class fileuploadserializer(serializers.modelserializer): def __init__(self, *args, **kwargs): many = kwargs.pop('many', true) super(fileuploadserializer, self).__init__(many=many, *args, **kwargs) class meta: model = fileupload read_only_fields = ('created', 'datafile', 'owner') class fileuploadviewset(viewsets.modelviewset): queryset = fileupload.objects.all() serializer_class = fileuploadserializer parser_classes = (multipartparser, formparser, ) def perform_create(self, serializer): file_list = self.request.data.getlist('file') ...
Read more