vba PasteFormat

Option Explicit

Sub PasteFormat()

    Dim fromRow As Integer
    Dim sRow As Integer
    Dim eRow As Integer
    
    fromRow = 6
    sRow = 7
    
    Rows(fromRow & ":" & fromRow).Select
    Selection.Copy
    
    Dim thisSheet As Worksheet
    Set thisSheet = ActiveSheet
    fromRow = 6
    sRow = 7
    eRow = thisSheet.UsedRange.Rows.Count
    
    Rows(sRow & ":" & thisSheet.UsedRange.Rows.Count).Select
    Selection.PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone, _
        SkipBlanks:=False, Transpose:=False
    Application.CutCopyMode = False
    
End Sub

  

how to fix local k8s cluster external-ip pending

 

install metallb

• kubectl apply -f https://raw.githubusercontent.com/metallb/metallb/v0.13.12/config/manifests/metallb-native.yaml

• #Install IPAddressPool and L2Advertisement
  k apply -f - <<EOF
  apiVersion: metallb.io/v1beta1
  kind: IPAddressPool
  metadata:
    name: default
    namespace: metallb-system
  spec:
    addresses:
    - 172.21.0.10-172.21.0.15
    autoAssign: true
  ---
  apiVersion: metallb.io/v1beta1
  kind: L2Advertisement
  metadata:
    name: default
    namespace: metallb-system
  spec:
    ipAddressPools:
    - default
  
  EOF
  

• Check external-ip of istio-ingressgateway
  > kubectl get svc istio-ingressgateway -n istio-system
  NAME                   TYPE           CLUSTER-IP      EXTERNAL-IP   PORT(S)                                                                      AGE
  istio-ingressgateway   LoadBalancer   10.43.236.164   172.21.0.10   
  15021:31478/TCP,80:32384/TCP,443:31061/TCP,31400:30774/TCP,15443:31366/TCP   82m
  

• nginx rancher should be in a same network,like rancher-default: 172.21.0.0/16

• ngingx need send/receive request/response to/from gateway(gateway in rancher container)

linux top command

$ top          # CPU使用率順にソート

$ top -a       # メモリ使用率順にソート

$ top -p [PID] # 特定のプロセスを監視

$ top -d1      # 1秒ごとに更新

ref: https://qiita.com/k0kubun/items/7368c323d90f24a00c2f