excel - vba Row numbers for filtered rows -

-

i have code capture row number in filtered table, things , go next visible row. works great first row.

sub test()  dim rn long dim cell range dim rng range       set rng = sheets("fabricatedparts").range("a:a").specialcells(xlcelltypevisible)         rn = sheets("fabricatedparts").usedrange.offset(1, 0).specialcells(xlcelltypevisible).row          each cell in rng             activesheet                 .range("b14").value = [parts].cells(rn, [parts[part.]].column)             end             'rn = next visible row #???.row          next cell  end sub

when change offset(1, 0) offset(2, 0) still returns row number first visible row(in case 10). looking vba statement return row number next visible row , pass number rn variable. filtered range testing next row number 11, next 165, next 166 etc. thank time.

use row number of cell loop.

sub test()  dim rn long dim cell range dim rng range       set rng = sheets("fabricatedparts").range("a:a").specialcells(xlcelltypevisible)          each cell in rng             rn = cell.row             activesheet                 .range("b14").value = [parts].cells(rn, [parts[part.]].column)             end          next cell  end sub

Comments

Post a Comment

Popular posts from this blog

Django REST Framework perform_create: You cannot call `.save()` after accessing `serializer.data` -

-
i have following viewset: class artistprofileviewset(viewsets.modelviewset): queryset = artistprofile.objects.all() serializer_class = artistprofileserializer def perform_create(self, serializer): if serializer.is_valid(): serializer.save() with following serializers: class simpleartisttrackserializer(serializers.hyperlinkedmodelserializer): class meta: model = artisttrack fields = (...my fields...) class artistprofileserializer(serializers.hyperlinkedmodelserializer): owners = userserializer(many=true, required=false) tracks = simpleartisttrackserializer(many=true, required=false) class meta: model = artistprofile fields = (...my fields...) i getting following error: assertionerror: cannot call `.save()` after accessing `serializer.data`.if need access data before committing database inspect 'serializer.validated_data' instead. i don't see editing serializer.data object. th...
Read more

Why does Go error when trying to marshal this JSON? -

-
i'm trying rather simple example of trying decode json file structs using golang. however, when attempting error that json: cannot unmarshal object go value of type []main.track which don't understand. here's code in question, , json can found here . package main import ( "encoding/json" "fmt" "net/http" "os" ) // tracks group of track types type tracks struct { tracks []track } // track represents singular track type track struct { name string url string artist artist } // artist represents single artist type artist struct { name string mbid string url string } func main() { url := "http://ws.audioscrobbler.com/2.0/?method=geo.gettoptracks&api_key=c1572082105bd40d247836b5c1819623&format=json&country=netherlands" response, err := http.get(url) if err != nil { fmt.printf("%s\n", err) os.exit(1) } de...
Read more