江宥蓉

畫圖 畫圖 '拷貝自https://excelatfinance.com/xlf19/xlf-... 'Dr Ian O'Connor, CPA. - located in Victoria, Australia. Option Explicit Const topleft As String = "C5" ' anchor cell Const diam As Integer = 180 ' points Sub xlfAddCircle1() Dim Shp As Shape Dim TLCleft As Double Dim TLCtop As Double TLCleft = Range(topleft).Left TLCtop = Range(topleft).Top Set Shp = ActiveSheet.Shapes.AddShape(Type:=msoShapeOval, _ Left:=TLCleft, Top:=TLCtop, _ Width:=diam, Height:=diam) With Shp .Fill.Visible = msoFalse .Line.Weight = 10 .Line.ForeColor.Brightness = 0.4 .ThreeD.BevelTopType = msoBevelCircle End With With Cells(1, 1) 'with 固定前面的物件end with .Value = "江宥蓉" .Interior.Color = RGB(0, 0, 255) ...

劉任昌107影片 我的EXCEL試算表 江宥蓉 Shift+Tab Shift 變速檔 shift gear preserve=保留 左Shift+Tab 右邊Tab gear齒輪 Enter 計算 註解 shift改變 shift 連續 16384 =COLUMN(天涯海角) Alt Ctrl 多重選擇 1048576 =ROW(天涯海角) Alternative 另外一個選擇 control 16384 =POWER(2,14) ctrl往上 1049576 =POWER(2,20) ctrol往左 ctrl往右 X24 16224 ctrl往下 F6 156 江 =Left(天涯海角,1) D4 4 江宥 =Left(天涯海角,2) 16384 =SUM(D8:D10) 宥蓉 =Right(天涯海角,2) 重選 =MID(B5,2,2) 劉任昌108影片